Fastest way of getting results from grid in query anyalser in SQL Server 2005 over to excel

Posted on 2007-08-09
Last Modified: 2013-11-05
What is the quickest way of getting results from grid in query anyalser in SQL Server 2005 over to excel with headers and appropriate formating
Question by:caseyrharris
    LVL 11

    Accepted Solution

    Go to Tools, Options, Query Results, SQL Server, Results to Grid.  Check the option for "Include column headers when copying or saving the results".  Then you should be able to do a CTRL+a and copy it all, then paste it into excel.
    LVL 3

    Author Comment

    Almost there, include column headers helps.  But, I still have a problem with the formating and not sure if there is a quick fix or just manually changing it in excel before the paste.  

    I have data like '0E0244' which should be text within excel, but comes across as this: 0.00E+00
    LVL 11

    Expert Comment

    Now that, I've never found a good way to do.  I generally just convert all of my columns in excel to text before I try to paste.  That way it doesn't try to do funky conversions like it does when the column type is set to General (which is the default).
    LVL 3

    Author Comment

    Thanks for the help!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
    by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now