Access and PHP

[Anon]

Is it possible to open ms access database with php? coz i'm trying to migrate access database to mysql. Coz i'm thinking, if i'm able to open the access database then i could create another connection in mysql and just issue insert command in mysql with data read from access database. am i correct in assuming this?

I really need an answer to this.

Thanks!

[Anon]

Create a data source name for the Access database in Control Panel->ODBC administrator. You can then connect to the database using $conn = odbc_connect("data source name", "username", "password").

You can query Access like such:
$q = "select field from table";
$results = odbc_do($conn, $q);
while(odbc_fetch_into($results, &$row)) {
$field = $row[0];
}

Good luck and don't expect much in the way of speed from Access.