excel importing xml data question -
11-27-2006
, 08:21 PM
I'm running a Universe system where they have a "TOXML"
Retrieve/Access/Recall operand.
By doing a simple list such as:
"LIST ICPM ITM DES.60 SIZ ICQF.DLR ICQF.DLS ID-SUPP LPTR TOXML"
to a spool hold file, and then exporting this file to Windows as a " ~~
..xml" file -
I can then open this file with Excel - and lo and behold - instant spread
sheet.
The problem is that Excel imports the data via a sort where column 1 is the
"DES.60" data, column 2 is the "ICQF.DLR" and so on where column 5 is the
"SIZ" data.
Clearly not the order that was specified.
Here is a snippet from the xml file:
<ICPM>
<ITM_MV ITM = "AJ15"/>
<DES.60_MV DES.60 = "2 DROP CORN/CALLOUS LIQUID REMOVER DR. SCHOLL'S
#26200"/>
<SIZ_MV SIZ = "PACK"/>
<ICQF.DLR_MV ICQF.DLR = "01-14-85"/>
<ICQF.DLS_MV ICQF.DLS = "04-19-85"/>
</ICPM>
<ICPM>
<ITM_MV ITM = "A431"/>
<DES.60_MV DES.60 = "ACT FLUORIDE DENTAL RINSE TRIAL/PREPRICED -
CINNAMON"/>
<SIZ_MV SIZ = "3 oz."/>
<ICQF.DLR_MV ICQF.DLR = "04-18-85"/>
<ICQF.DLS_MV ICQF.DLS = "02-04-85"/>
</ICPM>
The question is - does anyone know of a way to get Excel to import the data
is the same order as it was created?
Any help is appreciated.
Tom.... |