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 |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2009-02-12 : 11:22:25
|
| I ran a query which display result as grid including column header.How to save result to Excel file?I used copy and paste but column header were missed. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-12 : 11:25:38
|
| you've option in sql mangement studio options menu which says copy column headers while copying results. just check it |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-02-12 : 23:10:53
|
| try like this toogo to query --> results to file check the option and run the fileshortcut as ctrl+shift+f and run the query then it will ask to save file(.xls) give ur target destination |
|
|
|
Jai Krishna
Constraint Violating Yak Guru
333 Posts |
Posted - 2009-02-12 : 23:24:14
|
| To Include Column Header in the Result SetTools->Options->QueryResults->SQL Server->Results To Text->Now Select Tab Limited Option in Output Format Combo BoxAnd Also Check Include Column Headers in the Result TestNow Execute like thisquery --> click results to file option and run the filesave file with extension(.xls) When u save file save as type should be 'All Files'Jai Krishna |
|
|
|
|
|
|
How to save query result to Excel file?