Importing XML data

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 

So you've got a bunch of XML data. How do you get it into PowerPivot? Various ideas:

1. Import it into Excel using its normal data input capabilities. Once you've got the data into a worksheet, you have two options depending on if you are going to modify it later on. If the data is dynamic, i.e. you might change it by-hand later on, then mark the range and convert it into a table.

Read more...

 

Tags: load, feed

 

2007-2015 VidasSoft Systems Inc.