can anybody help me regarding this topic? when user click the export button, i have to export the data from my database to an excel file, which i managed to do. but now i have to create a pivot table in that excel file based on data in this table. how can
i achieve this?
what i tried so far, is to manipulate the sql query itself to pull out the data i want in the pivot table, but the presentation of the data is different from the actual pivot table that excel offers..
from my research for the past few days, i found out that we cant use Interop for this purpose. and the only other available methods i found are third party tool which i cannot afford. has anybody found a free solution? i cannot be the only one coming accross
this problem?
h3ctor83
0 Points
16 Posts
Export sql to excel and create pivot table
Nov 14, 2012 12:32 AM|LINK
hi all,
can anybody help me regarding this topic? when user click the export button, i have to export the data from my database to an excel file, which i managed to do. but now i have to create a pivot table in that excel file based on data in this table. how can i achieve this?
what i tried so far, is to manipulate the sql query itself to pull out the data i want in the pivot table, but the presentation of the data is different from the actual pivot table that excel offers..
from my research for the past few days, i found out that we cant use Interop for this purpose. and the only other available methods i found are third party tool which i cannot afford. has anybody found a free solution? i cannot be the only one coming accross this problem?
h3ctor83
0 Points
16 Posts
Re: Export sql to excel and create pivot table
Nov 14, 2012 01:37 AM|LINK
can anybody please advice?
Mark - MSFT
Contributor
7083 Points
435 Posts
Microsoft
Re: Export sql to excel and create pivot table
Nov 20, 2012 01:05 AM|LINK
Hi h3ctor83,
Could you elaborate on this? It's quite hard to offer solution without knowing your requirement.I'm not sure you have refered this or not, maybe it can help.
http://www.codeproject.com/Articles/22999/Creating-Pivot-Tables-and-Charts-Using-ActiveX
Best Regards
If you have any feedback about my replies, please contact msdnmg@microsoft.com
Microsoft One Code Framework