Conditions:
- Import tables through ODBC (through MariaDB in Linux version)
- Use the “Microsoft Access Driver” to add a new data source
Windows:
Select “Tools” in the
menu bar > Choose “Import from Database…” > Click “Manage Connection” > (Bottom left corner) “Manage
Connection” > Select “ODBC” in “New Connection” from the dropdown list
Go to “Administrative Tools” in Control Panel > Select
Database Sources
(select 32-bit ODBC Database Sources if using a 32-bit Navicat
Data Modeler; select 64-bit ODBC Database Sources while using a 64-bit Navicat
Data Modeler)
“User DSN” tab > Click “Add…” > Select “Microsoft
Access Driver (*mdb) > Input Data Source Name in the setup window > Click
“Select…” > Select database file > Click “OK” > Close the window when
finish the settings
Click “Manage
Connection” > “New Connection” > Select “ODBC” > Set up the connection
by inputting Connection Name > Select Data Source > Click “OK”
(You can also import
connections that established in other Navicat Software to Navicat Data
Modeler.)
Select the connection > Click “Manage Connection” > Choose “Import Connections from Navicat…”
> Select connection(s) to import > Click “OK”
Choose objects > Click
“Start” to import
Mac:
Select “import from Database” from “File” menu > Click “New
Connection” > Choose “ODBC”
Set up the connection
> Click “OK”
(You can also import
connections that established in other Navicat Software to Navicat Data
Modeler.)
Click “Import
Connection” > Select connection(s) to import > Click “OK”
Select the connection
> Click “Continue” > Choose object(s) to import > Click “Continue” >
Click “Import” to start
Linux:
Select “Tools” from menu
bar > Choose “Import from Database…” > Click “Manage Connection” >
Click “Manage Connection” button at the bottom left corner > Click “New
Connection > Select “ODBC” > Set up the connection > Click “OK”
(You can also import
connections that established in other Navicat Software to Navicat Data
Modeler.)
Click “Manage
Connection” > Choose “Import Connections from Navicat…” > Select
connection(s) to import > Click “OK”
Select the connection
> Choose object(s) to import > Click “start” to import
