Import Data Wizard

The Import Data Wizard allows you to import data to the existing table from one of the available file formats: MS Excel, MS Access, MS Word, HTML, XML, DBF, TXT, or CSV.

To run the wizard open the required table in the Table Data Grid View and click the Import Data button item on the toolbar or select it from the grid popup menu.

The first step of the wizard allows you to select the import source: the import file type and its name.

Select one of the available types from the drop-down list and specify the file name to import table data from.

The next step allows you to define the exact source for the Access or Excel file (table or worksheet) and specify the data preview options.

The appearance of this step depends on the file type selected on the previous step. For the Access file you have to specify the source table name, for the Excel file you should select a sheet by number or caption, for text files you can specify column delimiters and quote identifiers. Also for all file types you can customize the number of preview rows for the next wizard step, and select the row, which contain column caption, if necessary.

The third step is intended for displaying data preview - a sample of data taken from the source file.

This step does not contain any options or tuning. It only allows you to check the correctness of the previous settings and the source file.

The next wizard step allows you to map the target table columns with the columns from the source file.

Target Column contains all columns from the destination table. Source Column allows you to select the source column for each of them. The Set Default button reverts the mapping to its initial state, and the Clear All button clears all mapping.

Use this step of the wizard to adjust data formats used in the source file.

The edit boxes of this step allow you to set the format of reading specific date/time, integer, float, or boolean values from the source file.

The next step allows you to define the way of handling the identical values in the source and destination tables. You can also define the column(s), by which the identity should be checked.

The Append option ignores all identity and inserts all source records into the destination database; the Update option updates identical values and skips all other; Append/Update appends the new records and updates the existing ones; the Delete mode deletes all identical values and skips the others; and the Copy option clears all destination records, and inserts all identical.

The final step of the wizard starts importing, displaying the progress bar of the process.

Check the Abort Import On Error option to stop importing if any error occurs during the process.

To start importing with all the parameters you have set, click the Finish button. To abort the process of import click the Cancel button in the progress dialog.