Best Course to Import XML with DTD...
 

I have an a group of XML files that have a DOCTYPE declaration to a related DTD file.

I want to import these XML files using Excel 2003. I have attempted to use the Data-XML-Import menu option, with mixed success.

For example, the following group of lines causes the import to fail:

<field_def
<fieldnamecol_8_140 Dose Max (99.7%) <1900</fieldname
<datatypefloat</datatype
<dataformat%.3f</dataformat
<desc140 Dose Max (99.7%) <1900</desc
</field_def

Also, on another set of files, I get data truncation because there is so much data in one of the fields.

Do I need to write a custom parser or is there a better way?

Carl