To import data from an ODBC database

  1. Open the Data Transfer Tool.

  2. Select Import XML Filee from the main console or the Transfer menu. The Welcome to Import from XML File Wizard window will open, displaying a summary of the steps to be taken in the wizard.

  3. Click Next. The Choose a Source Database window will open.

  4. Select the database to export data from in the Database menu.

  5. Enter a user name and password into the appropriate fields.

    Note: DBA authority or higher is required to export a text file.

  6. Click Next. The Choose a Destination Data Source window will open.

  7. Select the database to import data to from the Database menu.

  8. Enter a user name and password into the appropriate fields.

    Note: DBA authority or higher is required to import a text file.

  9. Click Next, the Table Copy or Query window will open.

  10. Select from one of the three methods for data transfer:


Related topic:

Importing Data from ODBC
To import ODBC data from a list of tables

To import ODBC data using a series of SQL SELECT statements

To import data through an XML batch file