Perquisite: 32 bit Toad requires 32 bit ODBC drivers. 64 bit Toad requires 64 bit ODBC drivers. Create new ODBC connection 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 source database. Obtain a dataset in Toad by running a Select command in Editor or using Data tab of Schema Browser.
2. Right-click on top of data grid and select Export Dataset menu option.
3. Select “ODBC Database” option from Export Format drop down.
4. Select an existing ODBC connection from ODBC Connection drop down. Enter username and password credentials (if needed). Click Test Connection button to establish connection.
5. Adjust any necessary data export settings and select a target table name from Target Table Name drop down (Toad will automatically search for a matching object name).
6. Click OK button to export data.
