How to import table data via ODBC drivers?
Perquisite: 32 bit Toad requires 32 bit ODBC drivers. 64 bit Toad requires 64 bit ODBC drivers. Create new ODBC connections using Windows Data Source Administrator. On Start menu, click Control Panel | Administrative Tools | click Data Sources (ODBC). Read Bert’s related blog post on Toad World.
Important: Confirm successful connection to database using Windows Data Sources (ODBC) prior to completing below steps.
1. Make connection to target database and select Database | Import | Import Table Data menu option
2. Select Schema name from Schema drop down. Select object type from Object Type drop down and select target object name from Object Name drop down.
3. Click Show Data button to show existing table data of source object.
4. Click Next button and select “ODBC database” radio button.
5. Select an existing ODBC connection from ODBC Connection drop down. Enter username and password credentials (if needed). Click on Connect button to establish connection.
6. If connection is successful, then “Source Table Name” will populate objects from source database (Toad will automatically search for a matching object name). Select designated source object name and click Next button.
7. Adjust necessary settings on Source Data Detail pane and click Next button.
8. Import will read and show data from source object. The next three panes will allow to map and adjust columns between source and target objects.
9. In last pane of import wizard adjust any necessary import operation settings and click Execute button.
