July 20, 2004 03:20 PM

Sending Query Analyzer Results to Excel

Rating: (0)
SQL Server Magazine
InstantDoc ID #43115

I often send query results to users through email or copy the results to Microsoft Word documents. Query Analyzer in text mode provides headings for the query results, but the headings don't copy and display well in Microsoft Excel or email. I can use Query Analyzer's output-file option, but that requires more mouse clicks than I want. Is there an easy way to copy a query result's column headings and values from Query Analyzer to Excel?

...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

After copying the data to excel, insert one blank row.
Copy the header row and paste it in the first cell of the Excel spreadsheet on the empty first row.
Choose Data > Text to Columns option and follow the wizard to split the header row into the appropriate columns.


datalab 3/29/2005 7:24:55 AM


You must log on before posting a comment.

Are you a new visitor? Register Here