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);
HTML table data into a Access Databse table
Moderator: General Moderators