Toad Data Point 5.7 - Release Notes

Export Data with the Export Wizard

The Export wizard provides a single interface to select file formats when exporting tables and views, as well as their dependent objects or databases. This wizard is useful if you need to export the data you are working on to a database neutral format such as SQL statements, an Excel file, or a CSV file.

If you export multiple objects to Excel, Toad exports them to a single Excel file and each object displays on its own worksheet. You can also append objects to an existing file when you export to Excel.

Toad also provides another way to initiate the export process. Import Export Data Dialog

Note: Before you can export to Excel, the Primary Interop Assemblies (PIAs) for your version of Excel must be installed. If a required component is not installed, you are prompted to download it.

Considerations and Limitations for Exporting Data

Exporting Data

To export data

1. Select Tools | Import Export Data | Export Wizard.

   Tip: To export a single object, right-click the data and select Export Wizard or Send To | Export Wizard. The wizard opens on the Select Output Format page.

2. Complete the wizard. Review the following for additional information:

   Select Objects Page	Description
   Export Object	Select Add to include objects in the export. Note: After object selection and fulfilling next steps (see below), you will be back to this page and may select Add again to include objects of another type to the same export.
   Select Objects	Select one of the following object types in the export: Tables—Allows you to select individual tables to export. Views—Allows you to select individual views to export. Databases—Allows you to export all tables and/or views from a schema. Text list—Allows you to manually enter a list of objects that contain data to export. Query—Allows you to edit the SQL that displays in the Query field on the right side of the window before exporting it. Query file—Allows you to export an existing SQL file. You cannot edit this file.
   Select Output Format Page	Description
   Output format	Create as New Table—In addition to the standard output formats, you can select the Create As New Table option as an easy way to create and insert new data. Note: If you select the Create As New Table option, review the following: If you plan to import the data into a different database provider, you must create the column definitions for the import. You cannot use non-standard table names. SharePoint List—Select this option to update an existing SharePoint list or to create a new list. You must have a SharePoint URL defined in Tools | Options | Environment | SharePoint. Note: If you select the SharePoint List option to export a list that exceeds 5000 rows and you also select Recreate if exists, you will encounter an error message on export. This is because SharePoint enforces a list view threshold of 5000 rows.
   Check system resources	Select this checkbox to display a warning message if you do not have enough memory or disk space to export the data.
   Select Columns Page	Description
   	Select the columns to include in the export. Format—Click in the Format column to add a format for date and number type columns. Note: Formatting options are not supported for all column types.
   Select Output Options Page	Description
   Add Date/Time suffix to filename	Select to append a suffix to the file name. If you select this option, Toad always creates a new file even if you select to append it to an existing file.
   Select Excel Output Options Page	Description
   Excel file name	Click to select a file location and enter a file name.
   Start export at	Enter the column and row position to begin the export. Note: If you are exporting a single object to an existing worksheet, Toad exports the object to the selected column and row position. If you are exporting multiple objects, Toad exports each object to a new worksheet and the data starts at the selected column and row position.
   Overwrite	Select to overwrite the file. More About Excel Export Options about using the Overwrite option.
   Add Date/Time suffix to filename	Select to append a suffix to the file name. If you select this option, Toad always creates a new file even if you select to append it to an existing file. More About Excel Export Options about using the Date/Time Suffix option.
   Worksheet name	For a new file, enter a worksheet name. For an existing file, select the worksheet from the list. To add a worksheet to an existing file, select Append worksheet from the list and enter a new name. If you leave this field blank, the worksheet name defaults to the name of the object. Use this technique when exporting multiple database objects. If you are exporting using multiple queries, each query exports to a separate worksheet (Sheet 1, Sheet 2, etc.).
   Append rows	Select to append exported data to existing data on the worksheet with each execution of the Export Wizard template.
   Clear worksheet data before exporting	Select to clear the entire worksheet before exporting data. If you do not select this option, the worksheet contents outside the range of exported data are not cleared.
   Append timestamp to named worksheet	Appends a date/time suffix to the base name you specify in the Worksheet name field. In Automation, use this option to add a new worksheet with each execution.
   Save Settings as Template Page	Description
   Save template	Select this checkbox and specify a file name so you can use this against a similar database or in an automation script. Use Import and Export Templates

Tips: 

• To export data to Excel with a single click, use One Click Export. Export Data with One Click Export
• To run a macro when exporting to an Access database, use Automation and add a Run Program activity with the macro command in the Argument field. Use System Automation Activities

Related Topics

Import Data

Export Data with One Click Export