To import ODBC data using a series of SQL SELECT statement

  1. In the Import from ODBC wizard, select a source and destination database, and then select Table from the Table Copy or Query window.

  2. Click Next. The Source Query window will open.

  3. Click Add SQL. The SQL Query Statement window will open.

  4. Enter a valid SQL SELECT statement into the SQL Query field.

  5. Click OK. The Source Query window will reappear.

  6. Select or create a destination table from the Destination Table column.

  7. You may add more SQL query statements by clicking Add SQL, or modify the mapping of source and destination columns by clicking the Transform button.

  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 imported 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 import 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