Importing data from XML

  • Thread starter Thread starter Svilen
  • Start date Start date
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]
 
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...

Chip Pearson said:
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.
Click to expand...
.
Click to expand...
 
Back
Top