To import data with SQL DataTool, use the 'Import data' screen.
This screen allows you to import data from different types of source files to the target database to which the SQL DataTool is connected.
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 file type. 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 text file, or a (comma) separated file (.CSV).
- Folder: the import files are text files or (comma) separated files. The import files are located the same folder. This option allows you to import multiple files at once.
Source file: Depending on the source file type, you can select the file or the folder that you want to import.
The error message section contains the errors occurred 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 message box.
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 message box containing the messages on message type or on table. This allows you to look for details on specific imports. You can also filter on the message type. You can opt to see only the error messages, 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.