Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal
< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7
You are here: Work with Data > Export Data with the Export Wizard

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.

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

Consideration/

Limitation

Description

International characters When exporting data that contains international characters, make certain that your default character set is UTF-8. In the Export wizard,you must also select Unicode in the File encoding field on the Select Output Options page.
Fractional seconds

Consider the following limitations when exporting fractional seconds: 

  • When exporting to an Access Database File, exports do not support fractional seconds, so the additional data is not exported.
  • When exporting to an Excel instance, exports support only 3-digits for fractional seconds. However, if you export to an Excel file, it supports all fractional seconds.
Binary data types

Binary data types, including Filestreams, cannot be exported in this release. 
DateTimeOffset data types (SQL Server only) DateTimeOffset data types are exported as strings instead of DateTime to avoid losing time zone information.
HIERARCHYID, GEOMETRY, GEOGRAPHY data types (SQL Server only) HIERARCHYID, GEOMETRY, and GEOGRAPHY data types are exported as strings.
SharePoint Toad supports SharePoint 2010.

To export data

  1. Select Tools | Export | 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:

    • You cannot use non-standard table names.

    SharePoint List—Select to update an existing SharePoint list or to create a new list.

    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 date.
    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.

    Note: Toad only adds a suffix to a worksheet when the same worksheet name already exists in the file to which you are exporting.
    Select Excel Output Options Page Description

    Worksheet name

    Enter the name of the worksheet.

    This field is only available if you are exporting a single object. If you leave this field blank or are exporting multiple objects, the worksheet name defaults to the name of the object.

    Begin 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.

    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.

    Note: Toad only adds a suffix to a worksheet when the same worksheet name already exists in the file to which you are exporting.
    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. See Use Import and Export Templates for more information.

Tips: 

 

Related Topics

Import Data

Export Data with One Click Export