To import data through an XML batch file

  1. In the Import from ODBC wizard, select a source and destination database, and then select Batch file from the Table Copy or Query window. The Open window will open.

  2. Select an XML file from which to import the ODBC map schema.

  3. Click Open. The Table Copy or Query window will reappear.

  4. Click Next. The Source Tables and Views window will open, displaying a mapping schema according to the XML file.

  5. All tables from the source database will appear in the Source Table column. Check the box to the left of additional tables to import.

  6. For each source table or view selected, click the Destination Table field. If desired, change the name of the destination table by selecting a new table from the menu or entering a new name.

  7. You may modify column mapping or the result set to import by clicking on the Transform button of the corresponding source and destination table.

  8. Change the name of the destination column by selecting a new column from the menu or entering a new name.

  9. Click the Transformation tab to specify constraints on the result set. Enter a valid SQL SELECT statement into the Select SQL field, and a valid SQL INSERT statement into the Insert SQL field.

  10. Click OK to return to the Source Tables and Views window.

  11. You may also choose to save the map of the import ODBC schema to an XML file by clicking Save batch. The Save Batch File will open.

  12. Select or create an XML file to save the imported ODBC map schema to. Click Save Batch File to create the XML file. The Source Tables and Views window will reappear.

  13. Click Execute to import the source data. The Import Status window will appear.

  14. If errors appear, click View log and scroll to the bottom to see the error message. If no errors occurred, click Done.


Related topic:

Importing Data from ODBC
To import data from an ODBC database