Import data

To import data with SQL DataTool, use the 'Import data' screen.

Import data

This screen allows you to import data from different types of sourcefiles to the target database to which the SQL DataTool is connected.

Import data - general

The import data screen contains two sections: Import data selection and the error message section.

Import data selection

Select system: The system that contains the data model of the data that you want to import.

Select version: The version of the system that contains the data model of the data that you want to import.

Table prefix: Whether you want the imported table(s) to have a prefix. Default this is unchecked, so no prefix is added to the imported tables. If you check the table prefix box, you can add the prefix to the table. This will be used for all tables that will be imported during that run.

Source type: Select the source filetype. The options are:

  • MS Access file: the import file is an MS Access database file. SQL DataTool supports .MDB files and .ACCDB files.
  • Excel file: the import file is an Excel file. Using SQL DataTool allows you to import multiple excel sheets at once.
  • Text files: the import file is a textfile, or a (comma) separated file (.CSV).
  • Folder: the importfiles are textfiles or (comma) separated files. The importfiles are located the same folder. This option allows you to import multiple files at once.

Source file: Depending on the source filetype, you can select the file or the folder that you want to import.

Error message

The error message section contains the errors occured in previous imports. There are two types of messages, the information and error message. Messages of an import are stored on date and time of the import. You can also select previous imports. As a default, if an import has finished, the messages of that import will be listed in the messagebox.

Information messages contain information about which import and file has been successful or not. The error message contains information about what the error entails.

You can group the messagebox containing the messages on messagetype or on table. This allows you to look for details on specific imports. You can also filter on the messagetype. You can opt to see only the errormessages, and ignore the information messages.

It is also possible to delete the messages of an import. You can select the import and click on the delete button.