Toad Data Studio 1.1 - User Guide

Import Export Data Dialog

Use the Import Export Data dialog to define a source and destination for data import/export without going directly to the Import or Export Wizard. Use this dialog to consolidate the steps you normally perform prior to opening the Import or Export Wizard. Based on your selections, Toad opens the appropriate page of the Import or the Export Wizard pre-populated with the necessary information.

If you want to import data from a database object in one datasource to a new or existing table in another datasource, use this dialog. It provides the most comprehensive and streamlined method.

For new users, this dialog provides an easy way to get started with the import or export process. For experienced users, this dialog streamlines the steps of opening a connection and selecting a data source and destination. Toad automatically decides if the process is import or export.

Toad provides additional ways to initiate the data import or export process. See the following for more information.

• Import Data
• Export Data with the Export Wizard
• Export Data with One Click Export

To use the Import Export Data dialog

1. Select Tools | Import Export Data | Import Export Data or click the Import Export button in the main toolbar.

2. In the Define Data Import Export page, select a data source and then a destination for the data. Review the following for additional information:

   Note: If you do not select a connection in each datasource connection drop-down list, Toad automatically selects the currently-active open connection.

   Get Data From		Put Data In
   Datasource Object	Select to get data from a database object. Then select the source connection. Note: Use this option to get data from an Excel connection.	File (Export)—Export data to a file (Excel, .csv, etc.). See Export Data with the Export Wizard for additional information. Datasource Table (Import)—Imports data from a database object to a new or existing table in the same or another datasource connection. Also select the destination datasource connection. See instructions for the Add Table option in Import Data. The source is a database object. The destination is a table. SharePoint List (Export)—Export data to a list in SharePoint. See Export Data with the Export Wizard for additional information.
   Query Result	Use a query to get data from a datasource. You can enter a query or open a SQL file. When selecting this option, also select the source connection. You have the option to select the source connection on the next page of the Import Wizard, as well.	File (Export)—Export data to a file (Excel, .csv, etc.). See Export Data with the Export Wizard for additional information. Datasource Table (Import)—Imports the results of the query to a new or existing table in the same or another datasource. When selecting this option, also select the destination datasource connection. See See instructions for the Add Table option in Import Data. SharePoint List (Export)—Export data to a list in SharePoint. See Export Data with the Export Wizard for additional information.
   File	Get data from a single file (Excel, .csv, delimited text, fixed width, etc.).	Datasource Table (Import)—Imports the data from the file to a new or existing table in the selected datasource. When selecting this option, also select the destination datasource connection. See Import Data for more information about importing from a file.
   Folder	Get data from multiple files of the same file type in a directory. For example, you can select .xls or .csv files, but you cannot select a combination of the two.	Datasource Table (Import)—Imports the data from the files to a new or existing table in the selected datasource. When selecting this option, also select the datasource connection. See Import Data for more information about importing from multiple files.
   SharePoint List	Get data from a SharePoint list. Note: You must have a SharePoint URL defined in Tools | Options | Environment | SharePoint.	Datasource Table (Import)—Imports the SharePoint list to a new or existing table in the selected datasource. When selecting this option, also select the datasource connection. See Import Data for more information about importing a SharePoint list.

3. Click Next. Toad opens the appropriate page of the Import or the Export Wizard, based on your selections.

   For more information about import options in the wizard, see Import Data.

   For more information about export options in the wizard, see Export Data with the Export Wizard.

Related Topics

Export Data with One Click Export