dbTalk Databases Forums  

excel importing xml data question

comp.databases.pick comp.databases.pick


Discuss excel importing xml data question in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tom Phillips
 
Posts: n/a

Default 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....



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.