Import from a web page..?

[DerickD]

Hi all,

Thanks for taking the time.....

I am wanting to gether data from a web page that contains information regarding weather. It is possible to access this data unrestricted and with no copywrite so I am asking for you help.

The Data is spread over many pages and it is just a matter of changing a couple of numbers for each page.

Here is an example :

http://www.wunderground.com/weather...D=IZUIDHOL11&month=6&day=2&year=2003&format=1

I want to gether information for each day of the year...so I would want to have something like this :

Dim myDay
Dim myMonth
Dim myYear

myYear = 2002
myMonth = 1
myDay = 1

Do While myMonth <12
Do Wile myDay < 31

Import...blah..&quot;

http://www.wunderground.com/weatherstation/WXDailyHistory.asp?ID=IZUIDHOL11&month=&quot;

& myMonth & &quot;&day=&quot; & myDay & &quot;&year=&quot; & myYear & &quot;&format=1&quot;

myDay = myDay +1
loop

myDay = 1
myMonth = myMonth + 1
loop


This would then loop and import all the data for each day of 2002.

Does any one know how this could be done...using VBA in access or in any other MS application.

Thanks for the help,
derickd

 

[TimKThailand]

Check this ACC97: Example Using the Internet Transfer ActiveX Control out. Just save each page to a text file in your hard disk. Then import them in the db when you are off line.