Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Export SQL Server Outputs to separate Excel tabs

Author  Topic 

bmsra79
Starting Member

24 Posts

Posted - 2012-09-13 : 13:48:43
I need to export the results of around 15 SQL Server 2008 Queries to Excel 2010 file format.

I can either go with the outputs to multiple tabs in same Excel sheet (or) multiple excel files for each query.

What is the fastest and least manual way to do this.

I know that SAS can do this very quickly and easily. Is there any other method to achieve this using SQL Server 2008 and Excel.

I need to do this every Quarter.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-09-13 : 13:52:12
you can use OPENROWSET or export import for this

see

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -