Insert HTML table data into a Access database or Array

[hewstone999]

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);

[phparray]

Interesting.  Most of the time  you are creating and html table from data that exists in a database not the other way around. 

 

If this is just a one time thing you could copy and paste the html table from your browser window into an excel spread spreadsheet.  clean up the data if need be then import it into access.

 

 

[hewstone999]

The table is created by a user importing a .txt file and PHP reading the txt and creating a table. Now i want to insert those values into the access database.

 

Is there a way to access each value in the table i.e. Cell(A1)

[phparray]

Your should go directly from the txt file into the mysql db.  It was be one heck of a preg_match to do it the other way and very inefficient.