Importing data from XML

[Svilen]

I just wont to import and update the data supplied by this xml source:
http://www.ecb.int/stats/exchange/eurofxref/html/usd.xml into a normal xls
sheet. It seems easy and it worked until recently but now it doesn't work.
Seems like a sort of schema error but I don't understand what is wrong.

 

[Chip Pearson]

How were you trying to get the data? QueryTable? Direct via XPath? A
bit more detail would be helpful.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]

 

[Svilen]

What I am doing is just to open the link in Excel (File->Open). Then it asks
to choose how to open the document and I choose: As an XML list. There is a
warning about the schema and mapping after that. I pres OK and it loads
something which is very different from what is really in the document.
I suppose that there are smarter ways to do that...

How were you trying to get the data? QueryTable? Direct via XPath? A
bit more detail would be helpful.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]

I just wont to import and update the data supplied by this xml source:
http://www.ecb.int/stats/exchange/eurofxref/html/usd.xml into a normal xls
sheet. It seems easy and it worked until recently but now it doesn't work.
Seems like a sort of schema error but I don't understand what is wrong.

.