Import MS Access database

SQL DataTool allows you to import an MS Access database (either .MDB or .ACCDB). To import a MS Access file, you first have to define the data model like described in this manual.

To import the MS Access file, open the 'Import data' screen. Select the system and version that contains the required data model. And select whether you want the tables that will be imported to have a prefix.

Select the source type as a MS Access file and select as source file the file that you want to import.

MS Access import

During import, SQL DataTool looks for tables in the MS Access file that have the same name as tables defined in the data model. Tables that do not match the tablename are skipped. After import, a popup will show the tables that were expected, but not available in the MS Access file.