Import data into the model using a Macro in Excel 2013

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

In Excel 2013 Macro's now can talk to the Embedded Analysis Services engine. Here is an example created by my colleague Allan Folting that will import a table from the Azure datamarket into the Model using the Excel OM. The first thing you want to do when you want to create macro's is enable the Developer ribbon of Excel.

Read more...

Tags: load, excel

 

2007-2015 VidasSoft Systems Inc.