Importing data
When importing data as text, the Importing Assistant will walk you through the
following steps:
Select a file
The first step is to select the file you would like to import. You can use the
Choose button to select the file, or you can drag & drop the file on to the
file name display (which says <Unknown> by default). You should then select
Tab delimited or Comma separated as the format of the file.
Table selection
You will be presented with a list of the tables you can import the data into.
Select a table and continue to the next step.
Column selection
The next step is to select which columns the data should be placed into.
Check the columns to insert data into and use drag & drop to place them in the
correct order.
Error handling & options
Select what MacSQL should do if an error occurs during the import. For servers
with transaction support, the entire import can be wrapped in a transaction that will
be rolled-back on error. Otherwise, MacSQL can ignore errors or stop at the first error.
If the first line of the text file contains the names of the columns, check the
Skip first line of input checkbox. If you would like to replace all the data
currently in the table, check the Delete all rows before insert checkbox and
MacSQL will perform a "delete * from tablename" before beginning the import.
Do the import
The final step is to press the Start Import button. A progress bar will appear
showing you how far along MacSQL is in the import. You will be notified once the import
is complete.
Table of Contents