Use the ODBC DSN Fields Mapping tab to select the fields that you want to import from the ODBC DSN file and how the data is converted.
This tab is available if you set the
From option to
ODBC DSN on the Main tab.
Contents
| Field | Description |
|---|
| Include
|
Select the fields to include in the import. Use the
Up,
Down,
Top, and
Bottom buttons to reorder a selected field to match the structure of your ODBC DSN file. Click
Move Included Items Up to move all selected fields to the top of the list of fields.
|
| Field Names
|
This field displays all available fields in the table.
|
| Data Type
|
This field displays the field's data type, such as varchar, decimal, or integer.
|
| Expression
|
Use the drop-down list to select the corresponding field name from your data source. You can also enter an expression. An expression can be a simple as a default value enclosed in single quotes, or as complex as a calculation involving immediate IF functions, concatenations, and data type conversions. Syntax used in the
Expression field needs to follow your data source.
For example, if you are connecting to a SQL database, use CASE to test a field. If you are connecting to Access, use IF/THEN.
|