Choose your SQL server:
AnySQL
MySQL
MS SQL Server
PostgreSQL
Oracle
SQL Anywhere
DB2
SQLite
Firebird
MaxDB

Subscribe to our newsletter

PostgreSQL Data Wizard online Help

Prev  Return to chapter overview Next 

Excel

This step is available only if you have at least one Excel file to import. Select files from the file list and set correspondence between the source Excel columns and the target PostgreSQL table fields.  

 

Select ranges in the grid for the target field, selected in the Fields list. Click a grid column caption to select a whole column or row respectively. Using the popup menu of the Ranges list you can add or edit ranges manually, as well as remove them or change their order. After you define a range for the selected field, proceed to the next one. If the source file and the destination table have the same order of columns or rows, you can use the Auto Fill Cols or Auto Fill Rows buttons to set correspondence between them automatically.

 



Prev  Return to chapter overview Next