Can Excel 2008 open an xml file from and online database

M

Mitched

In the past Excel for the Macintosh has not had the capability of opening in a spreadsheet format xml files which come from online databases. Has this changed in Office 2008? Excel for windows has no difficulty with this process.
 
J

John McGhie

It depends on the XML :)

XML is a "language". Whether Excel can make sense of it or not depends upon
what the languages "says".

If you have the correct XSLT installed, then yes, Excel should be able to
read whatever you throw at it. You need to find out from the author of the
database which XSLT they are using, and possibly obtain the DTD and FOSI for
it as well.

Cheers


In the past Excel for the Macintosh has not had the capability of opening in a
spreadsheet format xml files which come from online databases. Has this
changed in Office 2008? Excel for windows has no difficulty with this
process.

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Nhulunbuy, Northern Territory, Australia
+61 4 1209 1410, mailto:[email protected]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top