I see frequently asked on various forum questions regarding pulling information off of websites. The concept is relatively straight forward, load a page, grab the content, parse what you need… You can use various need, get into textual parsing, DOM manipulation and extraction, …
There are a number of approaches that can be used, such as: Internet Explorer automation, MSXML2.XMLHTTP, …
As usual, the information on how to do this is sparse, and sometimes hard to find, especially when you don’t even know the proper terms to search for in the first place. Below are a few links to help you get on your way.
http://www.accessmvp.com/djsteele/smartaccess.html – Scroll down to the bottom and look at the article entitled: “April 2006: Surfs up!”
I scrape information from TheTVDB.com to rename my TV series. I search for a series, select a season, highlight the entire season’s information paste into a text document. Then I use an MS-Access app that loads and parses the data, very little code required. I can rename an entire season in 10-15 seconds regardless of the number of episodes.
Hello, I need som help to do scraping with ms access. Please contact me
I’d urge you to ask your question in a forum. Feel free to consult https://www.devhut.net/ms-access-forums-and-discussion-groups/ for a listing of some of the more popular Access forums.