Validating content from xml files
In this dialog box, click Details for additional information about each error.The following table lists some common import errors: Some or all of the data you imported was converted from its declared data type to text.
Trying to use the "publish_as_webservice" quickstart as an example for validating inbound message and not getting far.
Note: You can't export the Excel inferred schema as a separate XML schema data file (.xsd).
Although there are XML schema editors and other methods for creating an XML schema file, you may not have convenient access to them or know how to use them.
Excel converts data to text when: This problem can occur when you select more than one XML data file to import, and Excel can't find a matching XML Map for one of the files.
For the file named in the title bar of the dialog box, import an appropriate schema first, and then try importing the file again.
To use this data in a calculation, you'll need to convert the data from text to numbers or dates.