Viewing Nested XML in Excel

[michaelw00d]

Hi, I am new to the forum...thought I was quite competant with Excel until I came across a whole new world of XML....

I understand the basics, however what I am trying to do is view XML that may have several nests within it, for instance:

--> Customer Number, Name, Address etc
--> --> Order number, order date
--> --> --> product id, product price, product description

So a customer could place one or more orders which could have one or more products. In Excel I would want it to display the Customer with all his orders below, with each order detailing the products within it. If the XML file has several Customers, I would like this process to repeat in the Excel sheet.

Can anyone help me?

Thanks!
Michael