Web scraping in Access.

[revver]

I want to grab info from a website to include in my database. I have found many articles/questions on scraping using Excel but zero for Access.
Without going too deeply into the Excel info, I have found that I will need the name of the class of interest. I have that name now.

Can anyone point me to some appropriate resources so that I can research this? Are there any ways to do this that are to be preferred over other ways, given the choice; any pitfalls etc?

 

[Micron]

I just googled "ms access vba web scraping" and got 79 hits, some for Excel, some for Access. Some results were videos.
Since I know nothing about this topic and have no desire to, I only did a small review of the results. Perhaps they will help you though.

 

[revver]

Thanks Micron,
Perhaps I should have said zero useful articles relating to Access. It was so depressing sorting through the hits only to find nothing of much usefulness or really appropriate. That's where I found out about needing class info.

However, I have found a website that does seem like it will be helpful. I haven't done any experiments using this info yet but it looks promising. I found it by following a chain of links although it didn't show as a hit in my earlier searches. In fact, it appears that there may be other useful stuff there like an enhanced SQL editor.

The site is called DEVelopers Hut.

 

[Micron]

Can't help but wonder if there aren't better platforms for what it is I think you want to do.
Good luck with your project!

 

[jackd]

Watch this video and his download info.

 

[Micron]

Well, it looks like you found what you are after.