Getting data from a website

[DrQuality]

Hello! I was wondering if there was a way to get Access (or Excel) to go to a website, and get the information itself. The website I want to get the info off of has no images, java, or anything else... it's just a straight text chart (here it is http://www.nrcc.cornell.edu/cgi-bin/stn_list?kmss)!

Thank you very much! This could save me hours of backbreaking data entry!! haha

- Mike

 

[cpod]

You can use an Excel web query to download the page. On the Excel menu bar go to:

Data/Get External Data/New Web query

paste the URL, and Excel will download your data from the website.

 

[DrQuality]

THANK YOU SO MUCH!!! You have no idea how much time I'm going to save...!!

-Mike