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 > Import Data

Import Data

You can import data from a single file, from multiple files of the same type in a folder, from multiple files in different folders, from a SQL query, or from a SharePoint list. You can import data into a new or existing table.

Note: Attempting to import data that was exported to an Excel instance where the fractional seconds were truncated results in an error.

Considerations When Importing Data

Review the following information before importing data.

Consideration

Description

International characters

When importing data that contains international characters, make certain that your default character set is UTF-8. In the Import wizard, you must also select Unicode in the File encoding field on the File Preview page.

Processing row count

You can improve the efficiency of the import process by defining the block size (processing row count) for imported data.

To define the block size for imported data

Enter a value for Processing row count on the Select Target page of the Import Wizard.

Default is 500.

Use the following general guidelines when determining the row count:

  • For a small number of columns, increase the processing row count.
  • For a large number of columns, decrease the processing row count.
SharePoint Toad supports SharePoint 2010.

To import data

  1. Select the database connection on which you want to import data.

    Note: The Import Wizard will import data to the currently-active open connection.

  2. Select Tools | Import | Import Wizard.
  3. Use the Import Wizard to specify a data source and import options. Review the following for additional information:

    Import File Page Description

    Import objects list

    Step one: Select one of the following types of objects to import:

    • Add File—Select a single file to import. If you want to import multiple files, use the Add Folder button.
    • Add Folder—Add multiple files of the same file type from a directory. For example, you can select xls or csv files, but you cannot select a combination of the two.
    • Add Query—Open a SQL file or enter a query.
    • SharePoint—Select a SharePoint list to import.

    Step two: Select the source data and specify import options.

    If you need help specifying the import options for the object you selected, please see the specific instructions in the sections that follow.

    Step three: You can add additional objects to the Import objects list by selecting another import object type.

    Note: You can add multiple objects to the Import objects list to import all at one time. However, you can only import to one target—the currently active open connection.

    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.
  4. Click Finish to import the data and close the wizard.

To import one file at a time

  1. Select Tools | Import | Import Wizard.
  2. Click Add File and select a file.
  3. Click the following to review additional information:

To import a folder

  1. Select Tools | Import | Import Wizard.

  2. Click Add Folder.

    Notes: 

To import a query

  1. Select Tools | Import | Import Wizard.

  2. Click Add Query.
  3. Open a SQL file or enter a query.

    Notes: 

To import a list from SharePoint

  1. Select Tools | Import | Import Wizard.

  2. Click SharePoint.

    Note: You must have a SharePoint URL defined in Tools | Options | Environment | SharePoint.

  3. Select a SharePoint list to import.
  4. Select Exclude create/modify info to exclude the Modified, Created, Created By, and Modified By columns from import.

    Note: Toad supports SharePoint 2010 only.

 

Related Topics

Export Data with One Click Export