If this function was invoked from the context menu of a table, this field is prefilled with the schema containing that table and is not modifiable. If this function was invoked from the Database menu, this field is prefilled with "Main", but any attached database can be chosen instead.

If this function was invoked from the context menu of a table, this field is prefilled with that table and is not modifiable. If this function was invoked from the Database menu, this field is prefilled with the first database in the selected schema, but any table in the schema can be chosen instead.

The table should have the correct number of columns for the data to be imported, otherwise errors will occur, although the errors can be ignored.

Here you can set the file from which to import data. The search button to the right will bring up a file chooser dialog.

If this box is checked, header lines at the beginning of the imported file will be ignored and the box at the right is enabled to allow you to set the number of lines to be ignored.

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.

Preview of the first few rows as imported from the selected file. You can check the result of importing in this window.