Spool to different sheet of an excel file

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

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

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

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.

Report •

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 •

May 20, 2010 at 03:53:33

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