Help in Php MySQL to mdb conversion

Asked By Tikwa Zuph 0 points N/A Posted on - 02/03/2013

How can I convert a database from mysql so I can put it in Microsoft Access 2007 in .mdb format?  Need help in php mysql to mdb conversion.

• Status: Open
• Question Views: 981
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Nickersonee Kenneth 0 points N/A #198029

Help in Php MySQL to mdb conversion

Process of Database to MySQL Conversion

First of all, takes the object definitions from MySQL. Then converts them to a similar SQL server or SQL Azure objects ,

Secondly load this information into the SSMA metadata. It does not load the information in the case

Of SQL server.

Moreover you can view the objects and their properties by using the SQL Azure metadata explorer

If you want more you can see this link:- https://docs.microsoft.com/en-us/sql/ssma/mysql/converting-mysql-databases-mysqltosql

PHP MySQL to IMDb conversion

.You can create a CSV file from MySQL , then you import it into access. You can procedure OLEDB otherwise ODBC link to access  and must be capable to do the inserts that way.You also try to generate the IMDb file.I am pretentious that you have one made already, just want to transfer the data from MySQL  and import into access.

 

You can learn more from here:- https://stackoverflow.com/questions/3248493/export-mysql-database-to-microsoft-access-mdb

About Nickersonee Kenneth

Questions
2

Answers
9

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 02/09/2013
• Question Category: MS Access