Import File dialog when called from a data editor
This dialog opens when exporting delimiter-separated values from a data editor to a database.
- Table name, structure and data mappings
- DDL preview
- Encoding, Write errors to file and Insert inconvertible values as null
Table name, structure and data mappings
The name of the table.
The table comment.
Columns / Keys etc.
| Data mappings for columns, and the definitions of the columns, constraints and indexes. |
The statement or statements that will be run. You can edit the statements right in this pane.
Encoding, Write errors to file and Insert inconvertible values as null
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.