Data Importer

Data Importer is a tool for uploading data into the database. It can upload :


Access Data Importer

Data Importer can be accessed in two ways:

  • From the Application Menu > Data Tools > Import Data From File
Access 1
  • Right click on a table > Import Data From File
Access 2

Load Data

In the Data Loader dialog:

  1. Choose the file path and the characters type;
  2. Select the schema;
  3. Choose whether you want to import data in an existing table or create a new one.
Import Data
In the Settings dialog you can match the file columns with the database columns ( if the table already exists ) or edit the column definition if the column is new.
The other settings are for:
  • First line is header - If yes, the first line data won't be imported and used for setting the initial column names.
  • Using the Edit button you can:
    • Edit the separator character - is the character separating data values inside one record. This is usually comma ',', tab \t, ; or |. We try to automatically detect this character, but is not sure that we match the right one.
    • Edit the quote char - some values may be quoted in order to make possible including separator characters in a value field. For example if you use comma as separator, "Andre,Mike" is a single data filed.
    • Edit the escape character - quote character can be used as well inside the data field, but it has to be escaped. "Andre,\"Mike" is a valid construct, the " inside is escaped.
  • Date format and locale - if your input data contains date, time or timestamp fields, this is a pattern how the data looks like. Put the mouse over the tip label before this field to get some samples. Also look on google for 'SimpleDateFormat tutorial' to get into details. The combo box is editable, you can enter your custom pattern.
Import Settings

If you import data into a new table, the column editing won't be applied in the database. The table will be created first when you start loading the data.

If you choose to import data into an existing table, changing the column definition will change also the column in the database ( if your project is online ).

After starting the load operation, the load errors and the line numbers will show in the Error pane.