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.
| Author |
Topic |
|
sqllearner
Aged Yak Warrior
639 Posts |
 Posted - 2006-08-15 : 15:59:47
|
| How can save the results from query analyzer to a excel sheet with all the columns included as we do it through the DTS. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2006-08-15 : 17:59:42
|
| Iam sorry because I thought I posted in the wrong Forum.I wanted to post in Import/Export (DTS) and Replicationinstead I posted in Transact-SQL section first thats why I posted again..Sorry... |
 |
|
|
dpoirier
Starting Member
9 Posts |
Posted - 2009-10-14 : 23:14:21
|
| If you're interested, I created an SSMS 2005/2008 Addin that allows saving SQL query results as an XLS file, with header and value formats intact. You don't have to mess around with importing CSV.http://www.SsmsXlsExport.com/Cheers,David |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-10-15 : 02:41:53
|
quote:
Originally posted by dpoirier
If you're interested, I created an SSMS 2005/2008 Addin that allows saving SQL query results as an XLS file, with header and value formats intact. You don't have to mess around with importing CSV.http://www.SsmsXlsExport.com/Cheers,David
But the methods suggested here would do it FREEhttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926MadhivananFailing to plan is Planning to fail |
|
|
|
dpoirier
Starting Member
9 Posts |
Posted - 2009-10-15 : 18:29:47
|
| You're right it would, but you have to create an output file first with the headers, and you have to wrap your query with the insert statement.With the addin it's just click and go, very handy if you're doing ad-hoc queries all day and saving results often. I actually wrote it for myself to make my life easier. I'm definitely not saying your way doesn't work, this is just an alternative. |
|
|
|
|
|
|
Exporting to an Excel Sheet