Import Table dialog

This dialog opens when exporting data from one table to another one, or when exporting a table to another database or schema.

In this dialog, specify the data mapping info and the settings for the destination table.

Table name, structure and data mappings

Item	Description
Table	The name of the destination table.
Comment	The table comment.
Columns / Keys etc.	Data mappings for columns, and the definitions of the columns, constraints and indexes. To start editing the information for a column, double-click the corresponding line in the list of columns. Note the Mapped to field. This field lets you specify which column in the table being imported should be used as a source of data for the corresponding column in the destination table. If you clear this field, no data will be added to the target column. To remove a column, select the corresponding line and click .

Item

Description

Table

The name of the destination table.

Comment

The table comment.

Columns / Keys etc.

Data mappings for columns, and the definitions of the columns, constraints and indexes.

To start editing the information for a column, double-click the corresponding line in the list of columns.
Note the Mapped to field. This field lets you specify which column in the table being imported should be used as a source of data for the corresponding column in the destination table. If you clear this field, no data will be added to the target column.
To remove a column, select the corresponding line and click .

Item	Description
Data preview	The preview of data you are about to import. This tab is not available if you started the import by using the Export to Database command () in a data editor or in the Result pane of a query console.
DDL preview	The statement or statements that will be run. You can edit the statements right in the preview pane.

Item	Description
Write errors to file	If you select the checkbox, the errors that occurred during the import are written to the specified text file. For each of the errors the place where it occurred is indicated.
Insert inconvertible values as null	If you select the checkbox, NULLs will be inserted into the table for the data that cannot be imported.

Last modified: 23 April 2021