I posted yesterday on pulling the column headings from a SQL Server result set and transferring them to Excel.  I received a comment from Scott Stonehouse outlining a much easier way to do what I need to do.

Simply access the Tools Menu and select Options.  On the left, expand Query Results/SQL Server and select Results to Grid.  On the right check Include column headers when copying or saving the results.

Run a query in SQL Server Management Studio and select the contents of the result set.

 

Paste the results into Excel – like magic, there are the column headings.

 

To me, Scott proved what the Internet and blogs are for.  Teaching and Learning.