Php access data solution

For php access data operations, I have an access data file db. mdb. now I want to convert his data into mysql data. How can I operate this db. mdb using php. I only need to read it, and then insert the read information into the mysql database I created. That person has done it. thank you !, $ Mdb = & quot; database name php operation access data
I have an access data file db. mdb. now I want to convert his data into mysql data. How can I operate this db. mdb using php. I only need to read it, and then insert the read information into the mysql database I created. Thank you for doing this!

------ Solution --------------------
$ Mdb = "database name. mdb ";
$ Connstr = "DRIVER = Microsoft Access Driver (*. mdb); DBQ =". realpath ($ mdb );
$ Conn = odbc_connect ($ connstr, "", "", SQL _CUR_USE_ODBC );

$ Rs = odbc_exec ($ connid, "select * from table name ");
While ($ row = odbc_fetch_array ($ rs )){
// It can be directly used here, and it is not necessary to go to mysql
$ Row = array_map ('addslashes', $ row); // Escape Special characters
Mysql_query ("insert into table name values ('". join ("', '", $ row). "')"; // insert a mysql table
}