Re: Querying Access DB from MySQL

[Gaby Fersan]

Hi Stacy

I have pc with LAMP insalled.
I have used the following function to connect to an accesss database from the server using PHP.

the $sql_query variable contains the query to the accessdata base.
After reading the the access file I will write to Mysql database.

This will only work for php under windows OS.


$sql_query="Select test_person_id from ki_test_persons";
save_datato_acces($sql_query);

function save_datato_acces($sql_query)
{

$db_connection = new COM("ADODB.Connection", NULL, 1252);


$db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\\xampp\\htdocs\\test\\ki.mdb;DefaultDir=C:\\xampp\\htdocs\\test";

$db_connection->open($db_connstr);

$rs = $db_connection->execute($sql_query);

while (!$rs->EOF){
$test_person_id = $rs->Fields[0]->value;
tep_db_query("INSERT INTO ki_test_person_id_from_access (test_person_id) values (" . $test_person_id . ")");
$rs->MoveNext();
}

$db_connection->Close();
}