To copy an existing data type mapping set, select Tools > Data Type Mappings > Maintain Data Type Mappings.
- Select the Mapping Set to be copied from the list in the Maintain Data Type Mapping Sets window and then click the Copy button.
Change the name and description of the new Mapping Set as required.
Use the buttons on the right side of the Data Type Mapping Set window to add new conversion parameters, and edit, copy, or delete a selected parameter.
To move a parameter up or down in the list, select it and then click the Move Up or Move Down button.
The order of the data type mapping conversion parameters is significant because when loading a table, the procedure checks the data type mappings from top to bottom and stops when a data type and its parameters are correctly matched. A blank parameter means that it will match to anything.
Click OK when you're done. The new data type mapping set is listed in the Maintain Data Mapping Sets window.
Click OK or Apply to save the new data type mapping set.