from olap to excel -
04-26-2006
, 05:26 AM
Hi,
Im trying to insert into Excel result from Olap cube by exec procedure
with MDX function in SQL:
-----
declare @qry nvarchar(4000)
set @qry = N'select *
FROM OPENROWSET(''MSOLAP'',.....
WITH....
execute sp_executesql @qry
----
and write to Excel by CopyFromRecordset in vb.
That is to slow if sql working on 100%....
If there is other ways to get and insert into Excel result from cude?
Any code sample? |