MS Excel

First select the dataset field from the 'Fields' drop-down list. Then select the corresponding cells by clicking row or column caption (to select the whole row or column) or clicking the individual cells, using Shift and Ctrl keys.
You can also define the corresponding cells manually in the 'Cells' edit field. Use semicolon to separate multiple cells.
After you select all the corresponding cells for the current table field, proceed to another field and repeat all these operations for each dataset field.
If you don't want some first rows or columns of the source table to be imported, set the number of such rows in the 'Skip ... first row(s)' and 'Skip first ... col(s)' edit fields.
Auto fill cols- use this button to set the correspondence between the source table columns and the dataset fields automatically. It is convenient if they are ordered in the same way. First table column will correspond to the first dataset field, second column to the second field, etc. If quantity of the table columns exceeds quantity of the dataset fields, then the last columns will have no correspondence.

Auto fill rows- use this button to set the correspondence between the source table rows and the dataset fields automatically. It is convenient if they are ordered in the same way. First table row will correspond to the first dataset field, second row to the second field, etc. If quantity of the table rows exceeds quantity of the dataset fields, then the last rows will have no correspondence.

MS Access

First select the dataset field from the 'DataSet' list. Then select the corresponding field in the '<TABLE_NAME>' or 'Custom query' list.
Click button 'Add' to link these fields. These fields will be added to the list at the bottom of the window. Repeat these operations for each dataset field. If you want to remove the accordance you set, select the linked fields in the bottom list and click button 'Remove'.

Auto fill- use this button to set the correspondence between the source table fields and the dataset fields automatically. It is convenient if they are ordered in the same way. First table field will correspond to the first dataset field, second field to the second field, etc. If quantity of the table fields exceeds quantity of the dataset fields, then the last fields will have no correspondence.

DBF

First select the dataset field from the 'DataSet' list. Then select the corresponding field in the '<TABLE_NAME>.DBF' list.
Click button 'Add' to link these fields. These fields will be added to the list at the bottom of the window. Repeat these operations for each dataset field. If you want to remove the accordance you set, select the linked fields in the bottom list and click button 'Remove'.

Auto fill- use this button to set the correspondence between the source table fields and the dataset fields automatically. It is convenient if they are ordered in the same way. First table field will correspond to the first dataset field, second field to the second field, etc. If quantity of the table fields exceeds quantity of the dataset fields, then the last fields will have no correspondence

TXT

First select the dataset field from the 'Fields' drop-down list. Then set two separator lines to delimit the source table column. Click to add a separator, double-click to delete one. Drag separators to change the column width. You can also set the column starting position and the column width manually in the edit fields 'Pos' and 'Size'.
When you set the separators correctly, proceed to another field and repeat these operations for each dataset field.

If you don't want some first rows of the source table to be imported set the number of such rows in the 'Skip ... first line(s)' edit field.

CSV

If the delimiter you have defined on the first step was found in the source table, then you will find the table columns already separated and delimited. Select the dataset field from the 'Fields' drop-down list. Then click the corresponding source table column or set the 'Col' value manually. Repeat these operations for each dataset field.

If you don't want some first rows of the source table to be imported set the number of such rows in the 'Skip ... first line(s)' edit field.

Auto fill- use this button to set the correspondence between the source table columns and the dataset fields automatically. It is convenient if they are ordered in the same way. First table column will correspond to the first dataset field, second column to the second field, etc. If quantity of the table columns exceeds quantity of the dataset fields, then the last columns will have no correspondence.

Click 'Next' to continue or click 'Back' to return to the previous step.

Base Formats

Regional settings
Decimal separator - set a character, which delimits the decimal parts of the imported numbers.
Thousand separator- set a character, which separates the digit groups in the imported numbers.
Short date format, Long date format, Short time format, Long time format - use these edit fields to set the date and time formats.


Format options

Left quotation - set a character or a number of characters, which denote quoting in the imported strings.
Right quotation - set a character or a number of characters, which denote unquoting in the imported strings.
Quotation action - you can select 'Add' to add quotation marks to each imported string or 'Remove' to remove all the quotation marks from the imported strings.
Boolean true - set some variants of TRUE value representation in the imported table, e.g. 'Yes' or '+'. Use new line for each new variant.
Boolean false - set some variants of FALSE value representation in the imported table, e.g. 'No' or '-'. Use new line for each new variant.

Data Formats
On this tab you can customize the format of each imported field in case when additional formatting is required. Select the field in the 'Field Name' list and set its format in the proper edit fields.

Tuning

Generator Value - use this edit field to set the initial value of the autoincrement field.
Generator Step - set the step of the autoincrement field. If it is 0 then the value of the generator will be ignored.
Constant Value - use this edit field to set the constant value of the field.
Null Value - set the value, which will be understood as NULL to set the default value.
Default Value - set the default value of the NULL field.
Left quotation - set a character or a number of characters, which denote quoting in the imported string.
Right quotation - set a character or a number of characters, which denote unquoting in the imported string.
Quotation action - you can select 'Add' to add quotation marks to the imported string, 'Remove' to remove all the quotation marks from the imported string or 'As is' to save the original quotation marks.
Char case - set the case of the imported string. 'As is' saves the original string, 'Upper' sets the whole string to upper case, 'Lower' sets the whole string to lower case, 'UpperFirst' sets the first letter of the string to upper case, 'UpperFirstWord' sets the first letter of each word to upper case.
Char set - set the char set of the imported string to ANSI or OEM. 'As is' saves the original string char set.

Replacements

Use this tab to set the replacement list for the selected field. Fill the list in the following format:

<Value-to-find>=<Replace-with-Value>.
E.g., you set the following replacemts for the field 'Continent':
'South America'='S. America'
'North America'='N. America',
that means, that all the values 'South America' of the field 'Continent' will be replaced with values 'S. America', and values 'North America' will be replaced with 'N. America' respectively.

Click 'Next' to continue or click 'Back' to return to the previous step.

Import Options

Commit
Commit after done - check this option to commit the transaction after import is finished.
Commit after ... records - set a number of records, after importing which the transaction shall be committed.

Record count
Import all records - check this option to import all records from the source table.
Import only ... first record(s) - if you don't want all the records to be imported, set a number of records to import them from the source file. In this case only this number of records (beginning from the first one) will be imported.

Miscellaneous Add Type - select the method of adding data to the dataset: Append or Insert.
Save template to file - use this button to save current import options (source filename, field correspondence, format options, etc) to file to fasten the process of configuring your next import.

Click 'Execute' when you are done to start import, click 'Back' to return to any step of preparing import or click 'Cancel' to cancel import.