ODBC DSN Fields Mapping Tab of Import Utility

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.