Export to....another format than /"?%$ EXCEL 1

[stetou]

I'm using analysis services with Proclarity Analytics Platform 5.0
I would like to export the results of my queries into an SQL server table, an Access database or a text file...instead of Excel.
Why?? Because I have a lot of records and unfortunatly Excel doesn't support that much records.

Is there a way with MDX or another tool to export to another format than Excel. Or something to translate my MDX code to SQL so I can use it with the Query Analyser
Thanks!!!

 

[pelajhia]

Is this a one-time thing? if so you might consider batched exporting to excel and then importing into Access, etc.

 

[MDXer]

you should be able to utilize the OPENQUERY and issue the mdx within the open query.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck