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
 General SQL Server Forums
 New to SQL Server Programming
 export to excel file

Author  Topic 

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-02-14 : 00:43:31
Dear all,
i'm using sql server 2005.
i've 20 queries to run. all the out put should come into excel file and each one to each sheet.is it possible?i've following the great aricle given below.but i didn't get the desired output.i used DTS import and export. it works fine but i need batch file for this.
help me in this regard.

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

Vinod
Even you learn 1%, Learn it with 100% confidence.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-02-14 : 01:02:41
try this http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -