importing .xml

  • Thread starter Thread starter Bernie Yaeger
  • Start date Start date
B

Bernie Yaeger

How can you import a .xml file into Excel 2002 such that it will make use of
the corresponding .xsd? If you simply open the .xml, the data, column
headers, etc are not properly formatted for strings that appear to be
numbers, dates, etc.

Tx for any help.

Bernie Yaeger
 
To make Excel use your XSD, you must first attach it to the spreadsheet as
an XML Map. You can do this through Data > XML > XML Source..., then click
XML Maps... and select the XSD file that corresponds to your XML.

For a good example of how do this, see the Office Online article "Turn
around expense reports in a snap with Excel 2003 and XML", available here:
http://office.microsoft.com/en-us/assistance/HA011109661033.aspx. Good luck!
 
Bernie, you can do this by using an XML Map. XML Maps are Excel's way of
importing XSDs. The idea is that you attach an XSD to your spreadsheet as an
XML Map, and then drag appropriate elements from the map into your
spreadsheet to link your XSD elements to particular cells in the sheet.
There's a good example of this at Office Online:

http://office.microsoft.com/en-us/assistance/HA011109661033.aspx
 
Hi Matt,

Thanks so much for both responses. I will follow your suggestions and I'm
sure it will help me resolve my problems.

Tx again,

Bernie
 
Back
Top