ms-access database to mysql database by php

Question

How we can convert a ms-access database to mysql database by php… or How we can access a ms-access database by php..

Answer 1

For accessing a MS Access database on Windows through ODBC, see here.

Answer 2

How we can convert a ms-access database to mysql database by php

You can export via an ODBC connector or (if you don't have too many tables) you can export your data to a text file and then import it into MySQL (after creating the tables manually) via LOAD DATA. Right-click on the tables and choose Export for available options.

For more detailed info on migrating from MS Access to MySQL, check out this great article from the MySQL Dev Team:

http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html

How we can access a ms-access database by php

You can do this easily right through PDO.