Import Table Data

Data in supported formats can be imported into a chosen table directly in this dialog.

Import Table Data dialog

Schema to Import

Choose one of available databases. "Main" is the default. All attached databases are available.

File to Import

A file from filesystem.

Table to Import Into

Select the table for import. Only tables from chosen database are shown.

CSV-like

This type of import handles plaintext files with field separators and possibly using a quoting character. A nonempty field separator must be specified: it can be one or more characters and defaults to a comma as used by the data exporter. The quoting character is optional, but if set must be a single character and not the same as the first character of the field separator: it defaults to a double-quote as used by the data exporter. Field separators and newlines are not recognised inside a quoted field, and the quoting character followed by another one represents a single quoting character in the field. Blobs can be included using the same format as used in SQL statements.

MS Excel XML

This type of import handles special XML files used in MS Excel. This tool cannot import any other XML file. This import filter does not contain any options.

Preview

Live preview of the selected file. You can check the first few rows of the result of import in the window.