InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 08:39:52 GMT20http://www.sqlservercentral.com/Forums/Topic885872-338-1.aspxYou can also write the output directly to a file from SSMS.Choose 'output to file' instead of 'output to grid'.You might also like to check the option to 'quote strings containing list separators when saving .csv results'.Yet another alternative is to use the SQLCMD extensions built in to SSMS, there is an example [u][url=http://msdn.microsoft.com/en-us/library/ms174187.aspx]here on MSDN[/url][/u]Fri, 19 Mar 2010 03:51:57 GMTPaul Whitehttp://www.sqlservercentral.com/Forums/Topic885872-338-1.aspxYou could also put the query in the Excel spreadsheet using the external data source tool. Once that is done you could just refresh the spreadsheet on the fly.Fri, 19 Mar 2010 03:19:50 GMTtyson.pricehttp://www.sqlservercentral.com/Forums/Topic885872-338-1.aspxYou are welcome.Thu, 18 Mar 2010 15:47:00 GMTOTFhttp://www.sqlservercentral.com/Forums/Topic885872-338-1.aspxAH...I figured it had to be something simple like that. That did it! Thank you so much!Thu, 18 Mar 2010 15:39:09 GMTaberhttp://www.sqlservercentral.com/Forums/Topic885872-338-1.aspxThis 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 GridTick "Include Column Headers when Copying or Saving the Results"Thu, 18 Mar 2010 15:33:29 GMTOTFhttp://www.sqlservercentral.com/Forums/Topic885872-338-1.aspxI've got to be missing something pretty basic here because it doesn't seem this complicated. :w00t:I want to save the results of a query to an Excel spreadsheet. No problem, highlight the rows and columns and paste in Excel or right-click and save as a csv. However, neither of these bring accross the column names though and I have many columns that I would need to type into Excel.Is there a way to also grab the column names? Thanks!Thu, 18 Mar 2010 13:43:26 GMTaber