[ddeaton1987]

My title says exactly what I'm looking for but let me elaborate. I'm wanting to set up a query that will automatically update a table with weather highs and lows for the next (let's say) month's temperatures. For example: If i run the query today it would populate the highs and lows for every day for a set location, i will also give another example at the bottom. I would need this done for roughly 8-10 locations across the united states. I'm sure this is possible but I have no clue where to begin. The website i'm currently pulling data from manually would be "www.accuweather.com", however i do not know if their user agreement will allow this. If anyone can point me in the right direction that would be fantastic!

The information this would need to capture would be something like this:

Location - Date - High - Low... all in separate fields and of course covering at least a month's worth of temps outward

Detroit, MI - 11/10/12 - 78 - 34
Miami, Fl - 11/10/12 - 88 - 56

[ddeaton1987]

Anyone have any ideas? I'm still lost on where I would need to begin. Even if you could point me toward some sort of reading material that might help I would be appreciative!

[GunnerInc]

how about reading their TOS? http://www.accuweather.com/en/legal Sites usually have one to read. There are many weather APIs out there to do what you want. Some free, some charge... the pay services are usually better.

[ddeaton1987]

I appreciate the response however the "legal portion" isn't really what I'm after on this site. Where would I begin with attempting to make a connection or having access grab this information from a website similar to accuweather?

[GunnerInc]

Accuweather does not have an API to use anymore AFAIK...

http://www.programma...?apicat=Weather
http://www.webmashup.com/tag/weather/

Do a search for weather API....

The legal section SHOULD BE Important to you as it tells you what you CAN and CANNOT do with their data and servers

[ddeaton1987]

GunnerInc, on 10 November 2012 - 11:52 PM, said:

Accuweather does not have an API to use anymore AFAIK...

http://www.programma...?apicat=Weather
http://www.webmashup.com/tag/weather/

Do a search for weather API....

The legal section SHOULD BE Important to you as it tells you what you CAN and CANNOT do with their data and servers

Thanks, that's what I was interested in. And I didn't say the legal part wasn't important, just that I was on this site looking for the "how to" kinda pointers. Thanks again!