Import File dialog when called from a data editor

Table

The name of the 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 data column in the file being imported should be used as a source of data for the corresponding column in the database. If you clear this field, no data will be added to the target column in the database.

• To remove a column, select the corresponding line and click .

Encoding

The character encoding for your data in the source file.

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