Spool to different sheet of an excel file

Microsoft Sql server 2005 standard editi...
November 12, 2009 at 23:44:21
Specs: Windows Vista
Hi

I am trying to spool the output of 3 sql queries into different sheets of the same excel file.

Like
Query 1 result in sheet 1 of report.xls
Query 2 result in sheet 2 of report.xls
Query 3 result in sheet 3 of report.xls

Please provide solutions


See More: Spool to different sheet of an excel file

Report •

#1
March 30, 2010 at 14:03:12
Hi Chinu,

Did you resolve the issue you had with spooling to different sheet of an excel file? I am also having the same problem. Could you please post the reply if you have a solution.
thanks.


Report •

#2
March 30, 2010 at 14:23:32
I got the answer to the issue. You just need to open a new connection in the new sheet with your query in it.

Report •

#3
May 20, 2010 at 03:53:33
Hi,

I too have a requirement to do so. Could you please direct me to the solution here.

Thanks for your help.


Report •
Related Solutions


Ask Question