Importing web data into Excel 2000

[SteveG]

I want to be able to automatically import data from web sites into
Excel 2000.

An example web site would be ...

<http://www.ecb.int/stats/exchange/eurofxref/html/eurofxref-graph-
usd.en.html>

or using the link to the XML data file

<http://www.ecb.int/stats/exchange/eurofxref/html/usd.xml>

I have tried using "get external data" but it looks like I would have
to parse the data to make it usable.

What is the best way to do this?

 

[Don Guillett]

One way to start is from the web site>place your cursor where you can right
click to get an option to import to excel>do so and build your external
query from there. You then use macros or indirect formulas to extract the
desired data. What data are you trying to get? For a client, I recently
created a project that gets 4000 days of trading history for about 50 pairs
of currencies using onada.com
http://www.ecb.int/stats/exchange/eurofxref/html/eurofxref-graph-gbp.en.html
http://www.ecb.int/stats/exchange/eurofxref/html/eurofxref-graph-aud.en.html

 

[SteveG]

"place your cursor where you can right click to get an option to
import to excel"

I don't seem to see this! Is it available with XLS 2000? How
dependent am I on the web site design.

For info I want EUR:USD exchange rate and Oil price.

Thanks

Steve

 

[Don Guillett]

In excel 2003>data>import>new>Type or paste your url>import
http://www.ecb.int/stats/exchange/eurofxref/html/eurofxref-graph-usd.en.html

 

[SteveG]

Unfortunately I am blessed with XLS 2000.

Is there an alternative solutions?

Steve