how do i write my own xml schema for Excel?

[Cat Armbruster]

I have simple xml data files that I want to open in Excel and I need to
define the data field types as text and/or numerics. I'd like to attach a
schema to the data that defines these types but I can't seem to get it to
work. What would you write the schema in and what would be some simple
examples to accomplish this?
For example, xml tag names of <CustomerCode> is text and <Sales> is numeric
and they are the only two tags in a file and they repeat.

 

[Debra Dalgleish]

There's information on the Microsoft web site that may help you get started:

http://msdn.microsoft.com/office/understanding/xmloffice/default.aspx