Can I save the *.xsd schema that Excel infers from my xml source ?

[Guest]

I would like to be able to edit/re-use the schema that Excel inferred when I
asked it to map my source xml file.
Excel seems to have made a better job of producing an appropriate map of my
data files than my best efforts in Notepad, but I can see no way to save this
map out as a new xml schema.
Is there a way ???

 

[Jan Karel Pieterse]

Hi Nhojnesnah,

I would like to be able to edit/re-use the schema that Excel inferred when I
asked it to map my source xml file.
Excel seems to have made a better job of producing an appropriate map of my
data files than my best efforts in Notepad, but I can see no way to save this
map out as a new xml schema.
Is there a way ???

There is an XML toolbox available at MSDN:

http://www.microsoft.com/downloads/details.aspx?FamilyId=E315C516-2C2C-4870-A189
-D47A5D7FFEB3&displaylang=en

one of the options is to infer a schema based on the selection.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com