Extract web-data

[DianePDavies]

I would like to make a small application that displays key information
relevant to a specific project.

It could be
- an exchange rate
- oil-prices
- weather data for a specific location
- other data

All the data is available on various web-sites - but I would like my program
automatically to extract these values!

Any idea on how to do that? I imagine to do it in Access as I would log the
values in a table - but if other tools are deemed better for extracting
web-values - please let me know.

 

[Wayne-I-M]

It can be done in access - but much better (for the data you need) to do it
in Excel then import the new data into access if you need to store it
relationally.

 

[DianePDavies]

OK...

and how do I extract the data from the web-sites?

How do I specify what value to pick - and how exactly is it done? How does
the code for that look like..?

 

[Wayne-I-M]

So to have to tell you this - but the "only" way to gaurantee it is to pay
the wensite - or if you can't then find another website with the same info
that does charge.
OK you can try and grab the data but many websites change references each
day jus tto try and stop scrapping.

As I said, excel is your best bet. With access you need to write some quite
complex code even to get the whole thing started - I assume you need source
data and not just page data.

Try this for excel (which is designed for scrapping page data better than
access
http://office.microsoft.com/en-us/excel/HA010548481033.aspx

and if you have any problems you need to ask in the excel foru
https://www.microsoft.com/office/co...?dg=microsoft.public.excel.misc&lang=en&cr=US

Good luck