Data in supported formats can be imported into a chosen table directly in this dialog.
Choose one of available databases. "Main" is the default. All attached databases are available.
A file from filesystem.
Select the table for import. Only tables from chosen database are shown.
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.
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.
Live preview of the selected file. You can check the first few rows of the result of import in the window.