What would be good tools or methods to gather html table data off the web into a local Access97 MDB?
My main interest is in private web, perhaps my data but more often not. Where data is presented to user in 'readable' format, one would think a number of tools should be able to gather the data somehow. A look at a table page, then using 'save' as text or anything leaves me with nothing that looks like data.
If the table is presented by a query, and I can programatically manage the URL content to achieve the query result desired, how can I programatically retrieve the data within the table? For example:
http://{serverIP}/query.ASP?enter
me={value}
produces a result on the screen. I'd like it imported on demand thru the automagics. I'm thinking that M$ Visual tools ought to do that by now if not Access itself, but am fogging out on the how at the moment.
A direct link from access to the web-based table would be nice as well, but not knowing filename off-hand, even if it is and Access MDB source, even tho' it looks like I have read access permitted, I doubt a direct connect is feasible over a long haul. But am open to suggestions in that area as well, especially since the contents may be less abbreviated (I have in mind one particular column that looks to be truncated to fit on the screen, and another column that 'should be' among items in table but is not posted to web table).
How to do/ what's best tool? or are there none?
I'll post a separate Q; on identifying public web samples for this exercise to get us a common ground.