The Column Info screen displays when you click the Next button on the Export Wizard's Table Info screen.
NOTE: If you are updating existing rows in a table, you must map at least one key field and one data field. To designate a key field, right-click on a mapping and select Enable as key field. A key icon will appear to the left of the field name.
The Column Info screen includes the following settings:
Export all: Exports all the columns in the export table.
Note: When appending data to an existing table, appends will only occur for columns that exist in both the export table and the destination table.
Allow unrestricted mapping so that any Export column may be mapped to any Destination column: Relaxes Automator's type checking and relies on the OLE DB Provider to perform type conversions. For example, if you need to export a numeric value that is so large that it cannot be stored in Monarch as a number, you can export it as a character field. The character field can then be mapped to a numeric field in DB2, for example, and the OLE DB provider will perform the type conversion, if that functionality is available.
Export Column: Lists the columns in the export table that have been mapped to columns in the destination table.
Destination Column: Lists the columns in the destination table that have been mapped to columns in the export table.
Auto Map: Instructs Automator to automatically map columns in the export table to columns in the destination table that have the same names. Note: Columns that don't occur in both tables will not be mapped.
Add: Displays the Select Columns to Map dialog, with which you can map an export column to a destination column.
Edit: Edits the selected mapping via the Select Columns to Map dialog.
Remove: Removes the selected mapping from the list.
Remove All: Clears all mappings from the list.
Cancel: Cancels any changes you have made and closes the Export wizard.
Back: Displays the Table Info screen of the Export Wizard.
Next: Displays the Excel Advanced Features screen when exporting to Microsoft Excel.
Finish: Saves the current export settings and closes the Export Wizard.