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 |
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
 Posted - 2010-07-26 : 10:54:05
|
| How to save the result set to exce. using Sql server 2008 management studio.I dont see an option to save to excelPlease helpThanks |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-07-26 : 14:21:44
|
| right click on the database where you have your data stored.select "task" -> "export data" select your data source (database) and select your data destination (select excel file).go through the wizard and it will guide you through the process. you will have your sql data stored in excel file. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-07-27 : 04:53:20
|
What I do is run the query in query analyzer & then right click on the top left side of the resulset grid & select the option"Copy with Headers" & paste it in Excel.  Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless. PBUH |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Saving to Excel