Page 1 of 1

HTML table data into a Access Databse table

Posted: Mon Jan 26, 2009 7:57 am
by hewstone
I have a html table that contains data and i want to insert the data into an Access database. Any ideas how to do this?

Table1:

01, Rich, Mike, 23, fred lane,
02, James, milner, 45, School Lane,
03, Rob, Matthews, 89, College Road,


I connect to the database using this code:

$db_conn = new COM("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("./Database1.mdb").";";
$db_conn->open($connstr);