capture web page data to access 2003

  • Thread starter Thread starter GemTal.com
  • Start date Start date
G

GemTal.com

Where would one begin to capture web page data to access 2003?

We have breakdowns (data I want to capture) displayed on the casting web
site -
right clicking the page brings up a menu then
selecting VIEW SOURCE brings the text I would like to capture
SAVE AS allows creation of a text file that I would like to
UPDATE or APPEND as needed into our current projects database.

I assume it can be done - probably via windows explorer api(?) but really
have no idea where to begin.
 
You don't need any Windows API calls - they wouldn't help. Search Access
Help for the Open statement - it enables File I/O. After you have the file
opened and read into a buffer you will need to write a parser routine to
look for and extract the data you want to capture. It isn't going to be
trivial...
 
Thanks Ron - exactly what I needed to start. Will be back with parsing
issues soon, I expect! <g> Thanks
 
uh

if it's a pretty HTML table you want; you can just right-click link and
paste in a URL and it shoud show up just like a Excel-linked table; or
something along those lines
 
Back
Top