Import XML Data

[Ben Crinion]

Hi

I have a workbook which is used to define a report by allowing users to pick
field names from a list and specifying filters using drop down boxes, the
system then calls a webservice which returns an XML file containing the
report.

The trouble is that because the report fields are dynamic i cant place a map
on a worksheet to import the data into because i dont have a schema at
design time.

I can create a map on the fly but i dont know how to get that map onto a
sheet for importing the data.

I have control over the report generation so i can get the XML in whatever
format i like, so far i have tried the following 2 ways (See below).

Thanks
Ben

1. I cant get this to work as its to static
<data>
<row>
<Field1>value</Field1>
<Field1>value</Field1>
<Field1>value</Field1>
</row>
<row>
<Field1>value</Field1>
<Field1>value</Field1>
<Field1>value</Field1>
</row>
<data>

2. I cant get this to display the results correctly
<data>
<row>
<value name="Field1">value</value>
<value name="Field2">value</value>
<value name="Field3">value</value>
</row>
<row>
<value name="Field1">value</value>
<value name="Field2">value</value>
<value name="Field3">value</value>
</row>
<data>