Spreadsheet Importer
Kingsley Elmes. 11/02/08The 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 | ||
 [0] |
||
 |
 |
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 | ||
 [0] |
||
|
|
The spreadsheet page gives a preview of the spreadsheet's content.
|
|
|
| Spreadsheet Preview Page | ||
 [0] |
||
|
|
The database page gives a preview of the database table's content.
|
|
|
| Database Preview Page | ||
 [0] |
||
|
|
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 | ||
 [0] |
||
|
|
To launch a java webstart of the importer just click the link below.
<< back [0]