xml files and Excel 2008

[Doug Mitchell]

I download data from online databases and it arrives as am xml file.
Previous versions of Excel for Macintosh will not open these files in
a spreadsheet format. Has that changed in Excel 2008?

 

[Phillip Jones, CET]

2008 will open any xlsx files (xml based files).

I download data from online databases and it arrives as am xml file.
Previous versions of Excel for Macintosh will not open these files in
a spreadsheet format. Has that changed in Excel 2008?

--
------------------------------------------------------------------------
Phillip M. Jones, CET |MEMBER:VPEA (LIFE) ETA-I, NESDA,ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>

 

[CyberTaz]

I don't believe anything has changed in this regard. As in 2004, Excel 2008
can open & save XML Spreadsheet files but still offers no support for
importing other types of XML data that requires a schema.

Of course, the native file format (.xlsx) of 2008 is OOXML as with the
Windows Office 2007 product... But that's a different matter.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Jim Gordon MVP]

Hi Doug,

Can you provide a URL? You may be able to use a web query to import the
data.

-Jim

I download data from online databases and it arrives as am xml file.
Previous versions of Excel for Macintosh will not open these files in
a spreadsheet format. Has that changed in Excel 2008?

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info