V
Vagabond Software
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>
<fieldname>col_8_140 Dose Max (99.7%) <1900</fieldname>
<datatype>float</datatype>
<dataformat>%.3f</dataformat>
<desc>140 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
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>
<fieldname>col_8_140 Dose Max (99.7%) <1900</fieldname>
<datatype>float</datatype>
<dataformat>%.3f</dataformat>
<desc>140 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