I want to extract data from a particular website into my Access Database. At the moment I do a search which returns the whole dataset in 10 record chunks and I copy and paste it into my DB. I then press next and repeat the process. As there are over 80,000 records to deal with this takes a long time! Has anyone any ideas as to how this process might be automated?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Extracting data from web site
- Thread starter TonyS1952
- Start date
Depending on your VBA and ETL skills you could probably automate this process using a Web Browser control. This will allow you to [tt]Navigate()[/tt] web pages and expose the data they contain, all from the comfort of Access.
Here is an example in Excel that demonstrates what can be done with the WebBrowser control and with a little coding you could make do what you want in Access.
MSDN Home > MSDN Library > Office Solutions Development > Office Talk: Developing Integrated Office Solutions, Part 2
Hope this helps,
CMP
(GMT-07:00) Mountain Time (US & Canada)
Here is an example in Excel that demonstrates what can be done with the WebBrowser control and with a little coding you could make do what you want in Access.
MSDN Home > MSDN Library > Office Solutions Development > Office Talk: Developing Integrated Office Solutions, Part 2
Hope this helps,
CMP
(GMT-07:00) Mountain Time (US & Canada)
- Status
Similar threads
- Locked
- Question
- Locked
- Question