Online Documentation for SQL Manager for DB2

Selecting source file name and format


This step of the wizard allows you to select the source file format you need to import data from.

 

Source file name

Type in or use the ExplorerButton button to specify the path to the file using the Open file... dialog. The file name extension changes automatically according to the selected Import Type.

 

Import Data - Selecting source file name and format

 

 

Import Type

Specify the format of the source file. For details refer to Supported file formats.

 

CSV format parameters

For CSV import you should define Delimiter and Quote settings using the corresponding drop-down lists.

 

If you have chosen the MS Access type then the following dialog appears:

 

Import Data - Selecting source file name and format - Access password

 

 

Here you can enter the password for the created/updated table.

 

Click the Next button to proceed to the Setting fields correspondence step or to the Selecting data source step of the wizard if you have selected MS Access as the source file format.