Is there a straight-forward way to query an HTML table that is embedded in a web page from MS Access?
OK, before this question is dismissed as being totally off-the-wall, here was the thought process.
For years I've used a marvelous feature in Excel where you can link-or-import an HTML table from a web page. It is great as a safe-and-simple way to share and integrate data 'across the internet. Out of curiosity, I 'record'ed the sequence and examined macro code. I noticed it used a connection with a string that begins with "URL", somtething I've never seen before,.
So it got me thinking... if Excel's "Link to HTML table" is using a standard ADO connection string, shouldn't it work in other apps as well? However just copying the recorded conneciton string and trying it in Access VBA didn't work.
Perhaps the solution is in SQLXML... or the ADO text input. Best solution I can come up with is a function for loading an HTML into a temp table and working with that. But i'm hoping there is an easier method out there.