Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MDX Statement to an SQL Server Analysis Services with ADO
Hello,
can somebody tell me how to send a MDX statement to an Sql Server with Analysis Services using VB for Excel and ADO? I would like to write the result of the query into an Excel table. There is a simple description auf how to use "normal" SQL statements with ADO to an SQL Server he http://support.microsoft.com/kb/306125/en-us Unfortunately, I cannot find such a description for MDX statements. BTW, I do not want to use an Excel pivot table, I just want to import the "raw" data into Excel 2007 (or maybe 2003). regards arno |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 with SQL Server Analysis Services 2005 | Excel Discussion (Misc queries) | |||
Excel Add-in for SQL Server Analysis Services | Excel Programming | |||
Office Excel Add-in for SQL Server Analysis Services | Excel Programming | |||
Excel Add-in for SQL Server Analysis Services - refresh ør | Excel Programming | |||
Excel Add-in for SQL Server Analysis services - refresh problem | Excel Programming |