Tuesday, March 20, 2012

Save query results to Excel spreadsheet

When I run an existing query in Management Studio I get the expected results pane. If I try to copy and paste the results to an Excel spreadsheet I lose my column headers and formatting information. How do I save the query results to an Excel spreadsheet so that column headings and formatting info are preserved?

Thanks for any help you can offer...

I put the query in a view then export the view to excel.

No comments:

Post a Comment