Help in Php MySQL to mdb conversion

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #198029

Help in Php MySQL to mdb conversion

qa-featured

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

Related Questions