Importing data

What data can be imported

MacSQL can import data in the following formats:

SQL

The file should contain a series of SQL statements separated by semi-colons. Each statement will be individually sent to the server.

Tab Delimited

Each row of data should be a single line in the file, with the tab character separating each column.

Comma Separated (CSV)

Each row of data should be single line in the file, with the comma character separating each column. Each value can optionally be enclosed in quotes. If a quote character is actually part of the column data, two quotes should be in the file.