7th
I found Aaron Bertrand’s comment on February 23, 2007 at 7:56 AM on his own post tremendously useful for exporting data from SQL Server Management Studio to Excel.
Under “Tools | Options | Query Results | SQL Server | Results to Grid”, I recommend checking “Quote strings containing list separators when saving .csv results”. Without this option selected, fields containing commas separate into two fields when exported to Excel. This option seems to have come available with SP2, so if you do not see the option, you might want to inquire into that. While you’re in there, you may also want to check the boxes for including the query in the results and including column headers when exporting the results (I did).
The comment’s second tip about selecting “Save with encoding” from the drop-down next to the Save button and saving as ANSI rather than Unicode also proved useful for correctly opening Excel files through Windows Explorer.
