ODBC Table Select - Fields

 

ODBC Table Select

Table

Select the table to which you want to export. This field displays all tables defined in the ODBC table source.

 

Data Fields

This list box displays all data fields defined for the selected ODBC table. Double-click a field line to toggle the key flag from No to Yes and designate the data field as a key field. Flagging a data field as a key field allows the exported records to be updated to any existing records.

Key fields are used to match exporting records with any existing records. If a match is found, the export data is updated to the existing record. If no match is found, the export data is inserted (added) to the database. If no field is designated as a key field, the export data is always inserted (added) to the database.