Exporting data

Selecting an export format

MacSQL can export data in the following formats:

Tab Delimited

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

Comma Separated (CSV)

Each row of data is a single line in the file, with the comma character separating each column. If a column contains a comma, that value will be enclosed in quotes.

Microsoft Excel®

This option will create a file with the data in Microsoft Excel® format.

SQL script

This creates a text file with the necessary SQL statements to create the table, any indexes on that table, and the insert statements necessary to repopulate the table. This is commonly used as a backup mechanism, as you can import that file back into the database.

XML

Each row of data is inside a ROW tag, all of which are contained within a ROWS tag. Within each ROW there is the data for each column in a tag that is the column name.

HTML

Data is written in an HTML table for insertion into an HTML document.