handling xml "list of lists" in excel 2003

A

Aamer Akhter

Hello,

I'm trying to manipuate an xml doc that has a structure something like
this:

<node1 name="aa">
<node2>a</node2>
<node2>b</node2>
</node1>
<node1 name="bb">
<node2>c</node2>
<node2>d</node2>
</node1>

Is there a way to map this to a spreadsheet? Node1 and Node2
maxOccurs="unbounded".

If I drag the node1 element (and childern) to the spreadsheet, and try
to export the data excel complains that I have a list of lists and
mapped element's relationship with other elements cannot be preserved.
Which makes sense, but is there a way around this?

Thanks for any guidence.

Aamer Akhter
 
Top