Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : MS Access to Mysql PHP

[Danny159]

Hey,

Is there any way of looping through data in a MS Access Database and inserting it into a mysql DB?

Dan

[fabin]

you can connect to msaccess db using PHP and ODBC

[lynxus]

Originally Posted by Danny159

Hey,

Is there any way of looping through data in a MS Access Database and inserting it into a mysql DB?

Dan

Is this simply a case of migrating the database?
http://dev.mysql.com/tech-resources/...tive-grid.html

Otherwise then yeah, there is a way...

Setup a connection to your access db , While through the data and on every iteration do an insert using php/..

http://www.tizag.com/mysqlTutorial/

[raulgonzalez]

Try this

PHP Code:

 
<?php
//do a mysql connection here

//then connect to access using the following
$conn = new COM("ADODB.Connection") or die("Cannot start ADO"); 
    // Microsoft Access connection string.
    $conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=g:\\path\\to\\your\\database.mdb");
    // SQL statement to build recordset

    $rs = $conn->Execute("SELECT * FROM access_table WHERE something = '{$something}' ORDER BY something");
 
    $ID = $rs->Fields("ID");
    $something = $rs->Fields("something");
    
    $ID = $ID->value;
    $something = $something->value;

////////////////////at this point you do the insert to your mysql//////////////////
//mysql insert statement here
////////////////////at this point you do the insert to your mysql//////////////////

    $rs->MoveNext();
    } 

    $rs->Close(); 
//close mysql connection here
?>
 
I don't use it for that purpose since I have an export utility but I do use it on a page to select records from a mdb

[Lincxu]

If you just like to migrate access to mysql. there's a tool, just search "ms access to mysql".

[centauricw]

One word of warning when moving from Microsoft SQL (any of them) to MySQL. Database/Table/Column names in Microsoft are not case-sensitive, but they are case-sensitive in MySQL. If your web code doesn't use a consistent case the queries, things that worked on Microsoft will break on MySQL.

[Eiolon]

I used Bullzip to go from MS Access to MySQL with no problems.