Online Documentation for Data Import for SQL Server
Set correspondence between the target table fields and the source CSV file columns:
- select the Delimiter and Quote characters for CSV files using the corresponding drop-down lists of the CSV Parameters group;
- select a field of the target SQL Server table in the Fields list;
- proceed to the source grid viewer area: click a caption to assign the column to the selected target table field;
- the selected column of the source file gets gray highlight;
- repeat the operation for all the fields you need to be included in the import process.
The source file character set can be defined at the Encoding field.
If the source file and the destination SQL Server table have the same order of columns, you can use the Auto Fill Columns mode (default) to set correspondence between them automatically. If source file and destination SQL Server table have different order of columns but identical names you can use the Auto Fill by Captions mode to set the correspondence based on name's identity.
When you import data to a newly created table, the Analyze button appears. Use this button for automatic field creation.
If necessary, you can choose to skip a defined number of the source file rows using the Skip lines spin-edit.
The number of the column which correspondence is set for are displayed at the Grid Column column. You can use it for setting the fields correspondence as well.
To remove all correspondences, press the Clear All button.
If you choose to import data to the newly created table, at this step you need to create necessary fields. Use the corresponded context menu item to manage fields.
Note: If table was properly created or already exists, it will be marked with a tick . If an error occurs during table creation, this table will be marked with a cross .
Click the Next button to proceed to the Setting base data formats step of the wizard.