Title: Transfer mysql to access including relationships and foreign keys?
Tags: mysql;database;ms-access;mysql-workbench;er-diagram
Question: 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. ?)
Comment: mysql workbench is the name of a software used to access the database mysql. you are trying to transfer from mysql to ms access. workbench is the tool you used to use and is not mandatory.


Here is another answer: 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.

{'source': 'StackExchangeDataset', 'subset': 'stackoverflow.com', 'metadata': {'AnswerCount': 1, 'CommentCount': 1, 'ContentLicense': 'CC BY-SA 3.0', 'CreationDate': '2017:00:12/08/17', 'FavoriteCount': None, 'PostTypeId': 1, 'Tags': '<mysql><database><ms-access><mysql-workbench><er-diagram>', 'Title': 'Transfer mysql to access including relationships and foreign keys?', 'ViewCount': 146, 'id': 47707441, 'user_AboutMe': '', 'user_AccountId': 8418866.0, 'user_DisplayName': 'Gabriel', 'user_Reputation': 385.0, 'user_Views': 80.0, 'user_id': 6318255.0}}