Page 1 of 1

Insert HTML table data into a Access database or Array

Posted: Mon Jan 26, 2009 12:26 pm
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);