Microsoft Office Data Connection to utilise an external XML Data source?

1

I want to be able to process or product for connecting an external XML data connector to Microsoft Office Products (specifically Excel) so that it's seamless to the product. Essentially the spreadsheet should act as if it's running an SQL query and update each time that you open the file.

What would be the best way for doing this?

Edit (further information):

Worth noting: Mapped XML Data sources cannot be used in pivot tables. However I would like to use the external xml data source to create pivot tables as well, if this is possible.

Michael A

Posted 2011-12-22T23:43:42.233

Reputation: 173

Answers

2

You can use Excel Get External data and specify an XML data source. The data can be set to refresh on a variety of triggers including on file open. Once the data is in Excel, it can be used as the source of a pivot table.

Note I have done some very basic testing done on Excel 2010 to confirm these claims. I think 2007 should work in a similar manner

chris neilsen

Posted 2011-12-22T23:43:42.233

Reputation: 4 005

1This is essentially how I would do it also. – surfasb – 2011-12-23T04:43:51.197

Appreciated - will look into this further and see how I go – Michael A – 2011-12-23T07:16:42.180

Asked: 2011-12-22T23:43:42.233

Viewed: 749 times

Active: 2011-12-23T03:13:59.097