Home Forums SQL Server 2005 T-SQL (SS2K5) Saving query results in Excel with column names RE: Saving query results in Excel with column names
OTF
SSCertifiable
Points: 6054
More actions
March 18, 2010 at 3:33 pm
#1136350
This are the steps in SSMS for Sql 2008 but I think it should work for 2005:
Click on the Tools menu option in SSMS.
Click on Options->Query Results->Sql Server->Results to Grid
Tick "Include Column Headers when Copying or Saving the Results"