How do I get the headers from a SQL2005 query to excel2007

Question

In Excel 2003 I was able to copy query results with header from SQL2005. But In Excel 2007 will not allow me to copy the query result headers to the spreadsheet. Is there a converter that I need?

Answer 1

If you are using SQL server 2008 SSMS, you can right click on the result grid and select 'copy with header'.

---

Beyond Relational
SyntaxHelp.com

Answer 2

This can be achieved using sql serve 2008 SSMS, what you need just right click on the result panel and choose with the headers.

Thats it.

Hope this helps.

Answer 3

Clicking Tools -> Query Results -> Sql Server -> Results to Grid
and check the box that says 'Include Column Headers when copying or saving the results'

Maybe that got unchecked in the process somehow?

Is this what you were looking for?