Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1003
  • Last Modified:

After exporting sql grid results (or copy and paste in Excel) - Header is missing. How do I export (or copy) the column titles?

After the sql query runs, when I copy and paste (or export to .csv) results in Excel - the header doesn't come with it.  How do I get the header to copy over?
0
glabossi
Asked:
glabossi
  • 3
  • 2
1 Solution
 
chapmandewCommented:
in management studio, to go tools, options, query results, sql server, results to grid...make sure the option is checked to include column headers.
0
 
glabossiAuthor Commented:
THe funny thing is that it is already set like this?  I still can't get the headers!
0
 
chapmandewCommented:
Hmm...you've got me then.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
glabossiAuthor Commented:
Darn.  Me too!  It should be obvious that that would do it but I still get no headers!  I'm in SQL 2005 Query Analyzer.
0
 
chapmandewCommented:
Thats really wierd....its always worked for me....
0
 
AgeshCommented:
From MSSMS go to  QUERY---QueryOptions--Grid then CHECK on the 'Include column headers when copying or saving results'
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now