MDX Statement to an SQL Server Analysis Services with ADO

A

arno sebastian

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 here:
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
 

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

Similar Threads

MDX query to filter the cube 0
MDX formula 3
import Excel worksheet to SQL Server table 7
Changing pivot table ADO recordset 0
Page numbering with Merged Document and IF statements 1
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
VBA Excel data to SQL Sever table 1
Cubevalue (Excel 2007) versus Cubecellvalue (Excel 2003) 2

Top