• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 999
  • 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
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone 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