View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Francesco Sblendorio Francesco Sblendorio is offline
external usenet poster
 
Posts: 12
Default Is it possible to import XML with master-detail data into Excel 2003?

Yes, it's possible: the master-detail structure is flattened.
Example: this XML ...

<people
<department
<idFooBar001</id
<employee
<nameCharles</name
<age27</age
</employee
<employee
<nameJohn</name
<age21</age
</employee
</department
<department
<idHeyFoo002</id
<employee
<nameMichel</name
<age29</age
</employee
<employee
<nameHerbert</name
<age32</age
</employee
</department

is rendered like this:
ID NAME AGE
--------- -------- ---
FooBar001 Charles 27
FooBar001 John 21
HeyFoo002 Michael 29
HeyFoo002 Herbert 32