How all top level elements of XML into a Worksheet
 

For starters ... I'm using 2003 (I have 2007 available if I need it)

1. Import XML using Data-Import External Data-New Web Query

That works great.

2. Data-XML-XML Source brings up the XML Source pane

The online help tells you that you can drag and drop elements on to a
Worksheet.

But I can't figure out how to make it so that, say, element 1 goes
into rows 1-49 and element 2 goes into rows 50-99 etc.

Can this be done through the drag and drop interface?

Might someone know of a tutorial that shows how to do this (and not
just a generic Excel/XML/Tutorial)?


If it's not possible to do this, is the plan for developers to save
the XSLT and tweak it so that an MSXML transformation does the mapping
into the rows for you?

Thanks.