turkishgold
10-15-2009, 11:54 AM
Hi,
I'm trying to figure out how to take tab-delimited data in a web page and stream it into Access to parse the data into a table.
The data are in relatively consistent format, like this example:
hypertexttransferprotocol://waterdata.usgs.gov/tx/nwis/dv?cb_00060=on&format=rdb&begin_date=2008-10-11&end_date=2009-10-11&site_no=08100000&referred_module=sw
(note: i changed the HTTP part of the url to hypertexttransferprotocol - I wanted to include the URL as it's a key example of what I'm needing to work with)
I have a list of water quality sites in an access table that I want to loop through and swap out the site_no for each site in the URL, and then somehow access those data (stream?).
At this point I'm not real sure what I'm looking for with a method or other to stream the data or access them from the page as shown...
In this case I don't want to save the file to my machine, just scrape the data from the web
I'm relatively new to VBA
thanks,
Tom
I'm trying to figure out how to take tab-delimited data in a web page and stream it into Access to parse the data into a table.
The data are in relatively consistent format, like this example:
hypertexttransferprotocol://waterdata.usgs.gov/tx/nwis/dv?cb_00060=on&format=rdb&begin_date=2008-10-11&end_date=2009-10-11&site_no=08100000&referred_module=sw
(note: i changed the HTTP part of the url to hypertexttransferprotocol - I wanted to include the URL as it's a key example of what I'm needing to work with)
I have a list of water quality sites in an access table that I want to loop through and swap out the site_no for each site in the URL, and then somehow access those data (stream?).
At this point I'm not real sure what I'm looking for with a method or other to stream the data or access them from the page as shown...
In this case I don't want to save the file to my machine, just scrape the data from the web
I'm relatively new to VBA
thanks,
Tom