Transfer mysql to access including relationships and foreign keys?

176 Views Asked by At

Is it possible to convert My ER diagram/database from MYSQL WORKBENCH to MS ACCESS?

Will it include all the tables with their relationships to each other?

(foreign keys, data types one to many designations etc. ?)

1

There are 1 best solutions below

0
On

You can check this for information on transferring from mysql to ms access.

https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-import.html

These tools generally copy all table constraints as well.