Spreadsheet Importer

The Spreadsheet Importer is designed to make it easier to import and export excel spreadsheets when working with a SQL database.

Features

• Compare column headers within a spreadsheet and database table and make changes to the column names, types and sizes.
• View results based on the import i.e. New rows and updated rows.
• Export database table contents to a spreadsheet.
• Choose to Replace, Append, Merge or Sync spreadsheet data with database data.
• Save projects you are working on for future use.

Benefits

• Easily upload and export data to a database when working with Excel and SQL.
• Work with SQL database tables offline and upload your changes when you are done.
• Quickly modify tables using the different upload types.
• Import errors are saved to a database table for easy reference and quick modification of spreadsheets.

The welcome page allows the user to select a spreadsheet to import, set database connection settings and select a table to upload data to.

	Welcome Page

The comparison page give a side-by-side view of the spreadsheet and database table column headers. The user can then modify the spreadsheet header names, set the type for each column and set the size of the fields in the database.

	Compare Structures Page

The spreadsheet page gives a preview of the spreadsheet's content.

	Spreadsheet Preview Page

The database page gives a preview of the database table's content.

	Database Preview Page

The upload page allows the user to select an upload type and upload data into the database. Upload types include replace, append, merge and sync. The user can also save the table contents to a spreadsheet.

	Upload Data Page

To launch a java webstart of the importer just click the link below.

<< back