I was just wondering if it is possible to program Access so that it will go to a website, enter search criteria and then copy the resulting data.
I have recently been asked to track the weather condition in cities where my company's equipment has problems. The website that I found to capture this information is http://www.wunderground.com/history/. Right now, I have to go to the website, enter the zip code for the city, enter the date I need the weather for (yesterday's date), click the submit button, and then fill in the information that I see on that website in my database. Can Access do those steps for me, so that all I need to do is click a button? I'm attaching a snapshot of some of the information that I am copying to my database. Any advice or direction you can provide would be greatly appreciated.
I have recently been asked to track the weather condition in cities where my company's equipment has problems. The website that I found to capture this information is http://www.wunderground.com/history/. Right now, I have to go to the website, enter the zip code for the city, enter the date I need the weather for (yesterday's date), click the submit button, and then fill in the information that I see on that website in my database. Can Access do those steps for me, so that all I need to do is click a button? I'm attaching a snapshot of some of the information that I am copying to my database. Any advice or direction you can provide would be greatly appreciated.