How all top level elements of XML into a Worksheet

  • Thread starter gimme_this_gimme_that
  • Start date
G

gimme_this_gimme_that

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top