we have a web page that has a table in it with about 900 rows. we need to export this data into our access database.
the webpage is very simple and does not include anything expect for the table containing the data. The page was created as the result of a query done on our database, unfortunately we dont have access to the actual data and need to pull it from the html file.
We tried copying and pasting the table but that did not work, if you have any ideas that would be great. otherwise i believe we will have to write a simple program to read the data and create the records in the access table.
One thing to keep in mind, is that the field names are not the same in both tables.
We are looking to get this done in the next day or two.