You can use the Import Wizard to 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.
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:
|
SharePoint® | Toad supports SharePoint 2010 and 2013. |
To import data
Select the database connection on which you want to import data.
Note: The Import Wizard will import data to the currently-active open connection.
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:
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 |
Import Data Now |
Select to import the data immediately. |
Import Data Later |
Select to import the data later using the template. You must also select the Save template option and specify a file name and location. |
Send to Automation |
Select to send your import options to the Automation guided wizard to help you easily create a basic Automation script for importing data. You must also select the Save template option and specify a file name. See Automation Tutorial and Guided Tour for more information. |
Save template |
Select to save your import options as a template which you can later use against the same or a different database connection or in an automation script. See Use Import and Export Templates for more information. |
To import one file at a time
Click the following to review additional information:
File Preview Page | Description |
Column name as header |
Select this checkbox if the first row of the file uses column headings, and the actual data begins on the following row. |
|
Select to see Excel preview and to specify a range of cells to be imported manually. |
Transpose All |
Select this checkbox to switch the order of columns so that they display down the first, left set of rows, while data from the rows displays in columns. |
Normalize Columns |
Select this checkbox to group several column headers as values under other header and to put their values in the next column. Press
|
Start column |
Select the column where you want to begin importing data. By default, this begins at the first column. Tip: Click |
Column count |
Select the number of columns you want to include in the import. By default, all columns are imported. |
Start row |
Select the row where you want begin importing data. By default, this begins at the first row. Tip: Click |
Row count |
Select the number of rows you want to include in the import. By default, all rows are imported. |
Tip: You can filter data for each column by clicking |
Select Target Page | Description |
A single existing table |
Select to add data to an existing table. |
A single new table |
Select to create a new table. Default On Error—Select a default value. When data fails to import because of an error, Toad enters this value in the cell in place of the data. |
Processing row count |
Enter a value for the number of rows to process at one time when importing data. To enable this field, clear the Optimize block size check box. |
Optimize block size |
Select to optimize import by allowing Toad to determine the optimal block size. |
Identity inserts |
Select to enable importing into identity columns. Note: Identity column should be set to GENERATED BY DEFAULT. |
File Preview Page | Description |
Column names as header |
Select this checkbox if the first row of the file uses column headings, and the actual data begins on the following row. |
File encoding |
Note: When importing data that contains international characters, make certain that your default character set is UTF-8. You must also select Unicode in the File encoding field. |
Use current regional settings |
Select to interpret imported data using your regional settings. Deselect to interpret imported data using "United States" regional settings. Note: You can change the regional settings using your PC's Control Panel. See your system's documentation for more information. |
Select Target Page | Description |
A single existing table |
Select to add data to an existing table. |
A single new table |
Select to create a new table. Default On Error—Select a default value. When data fails to import because of an error, Toad enters this value in the cell in place of the data. |
Processing row count |
Enter a value for the number of rows to process at one time when importing data. To enable this field, clear the Optimize block size check box. |
Optimize block size |
Select to optimize import by allowing Toad to determine the optimal block size. |
Identity inserts |
Select to enable importing into identity columns. Note: Identity column should be set to GENERATED BY DEFAULT. |
File Preview Page | Description |
Column names as header |
Select this checkbox if the first row of the file uses column headings, and the actual data begins on the following row. |
Note: The preview is based on the first 50 rows in the file. |
To import a folder
Select Tools | Import | Import Wizard.
Click Add Folder.
Notes:
To import a query
Select Tools | Import | Import Wizard.
Open a SQL file or enter a query.
Notes:
To import a table or other database object
Select Tools | Import | Import Wizard.
Select a database/schema in the source. Then select a database object to import as a table to the same datasource. Click Next.
Select Target Page | Description |
A single existing table |
Select to add data to an existing table. |
A single new table |
Select to create a new table. Default On Error—Select a default value. When data fails to import because of an error, Toad enters this value in the cell in place of the data. |
Processing row count |
Enter a value for the number of rows to process at one time when importing data. To enable this field, clear the Optimize block size check box. |
Optimize block size |
Select to optimize import by allowing Toad to determine the optimal block size. |
Identity inserts |
Select to enable importing into identity columns. Note: Identity column should be set to GENERATED BY DEFAULT. |
To import a list from SharePoint
Select Tools | Import | Import Wizard.
Click SharePoint.
Note: You must have a SharePoint URL defined in Tools | Options | Environment | SharePoint.
Select Exclude create/modify info to exclude the Modified, Created, Created By, and Modified By columns from import.
Note: Toad supports SharePoint 2010 and 2013.
© ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center