[AccessD] Gather Information from Website

If you are interested, you may be able to glean something from an Excel
example that I ran across.

http://www.cpearson.com/Zips/STOCKWEB.ZIP



Mark


-----Original Message-----
From: Lavsa, Rich [mailto:Rich_Lavsa at pghcorning.com] 
Sent: Wednesday, June 11, 2003 8:56 AM
To: 'accessd at databaseadvisors.com'
Subject: [AccessD] Gather Information from Website


Hello all,

currently I am not developing this application, however since the topic of
web pages in access came up I thought that maybe I'd throw out a bone to see
if I can gain any knowledge before I attempt this on my own.

My goal is to come up for a friend of mine that runs 3 to 4 fantasy baseball
and football leagues every year and is thinking of getting into hockey next.
he spends all his time looking on the internet and local paper to get stats
they he puts into an excel spreadsheet manually just about every day.  There
is a large possibility that he could miss something, or add his points
system wrong, or simply enter it in the wrong cell.  My thought was that
this information is already entered in databases, and is displayed on
hundreds of websites.  So I was thinking that since this information is
already out there, why can't you just capture the stats every night.  Of
course there would be some work on setting up the database, setting up the
rules of each league, however thought it might be a fun project and the more
I think about it the more work I think it will be.

So to my question... 
Is it possible to navigate out to a website for Stocks or Sport Stats,
download the information from the website to your database? Has anyone out
there done anything like this?

Thanks in advance,
Rich
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com