[AccessD] Gather Information from Website

Rich,

Yes, this can be done - I did that for a customer to collect the info they
are interested in and AFAIK it works now for several years without problems.
It's better - more reliable and controllable - to use XMLHTTP from
MSXMLx.dll (x>=3) to get web pages.

In general your task is one of the tasks what web services should be used
for - I mean the sources of information in the (near?) future will publish
their data as web services not only as web pages - then the task to collect
this info will be a childish game - and coming version(s) of MS Office will
be tuned to work natively with such Web-services... Well, they will probably
charge something to get access to such web services...

HTH,
Shamil

----- Original Message -----
From: "Lavsa, Rich" <Rich_Lavsa at pghcorning.com>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, June 11, 2003 4:56 PM
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