To
import data from an ODBC database
Open the Data Transfer Tool.
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.

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

Select the database to export data from in the Database menu.
Enter a user name and password into the appropriate fields.
Note: DBA authority or higher is required to export a text file.
Click Next. The Choose a Destination Data Source window will open.

Select the database to import data to from the Database menu.
Enter a user name and password into the appropriate fields.
Note: DBA authority or higher is required to import a text file.
Click Next, the Table Copy or Query window will open.

Select from one of the three methods for data transfer:
To import data from a list of tables, select Table.
To import data using a series of SQL SELECT statements, select SQL query.
To import data through an XML file, select Batch file.
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