I've attached a representative sample of the Access 2010 database that I am working with. There are two tables in the database: thomasdata and billinfo. In the thomasdata table there are three columns but of interst is a unique id (ID) and a hyperlink (BillInfo). in the billinfo table the columns of interest are the thomasdataID and the billsummary columns.
What I would like to do is develop VBA to read the thomas data and pull the ID and the hyperlink from the thomasdata table. Then I would like access to follow the link to the webpage and scrape the information between the tags <a name="summary">SUMMARY AS OF:</a> and <a name='major actions'><b>MAJOR ACTIONS:</b></a>. Once that information is pulled, I would like the unique ID from the thomasdata table stored in the thomasdataID column in billinfo table and the summary of the webpage to be stored in the billsummary column of the billinfo table.
I know that this must have been done somewhere before, so I am hoping one of the experts can help find a solution.