troubleshooting Question

Querying an HTML table with SQL?

Avatar of sandy_beach
sandy_beach asked on
DatabasesMicrosoft AccessSQL
7 Comments1 Solution599 ViewsLast Modified:
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.

ASKER CERTIFIED SOLUTION
sandy_beach

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros