Post reply

Copy Query Analyser results pane including header

  • September 26, 2007 at 1:58 am

    #118725

    I knew how to do this before but, for the life of me, cannot remember now. I want to copy the results pane including the header into an Excel spreadsheet. How do I do it?

    :Whistling:

    Madame Artois

  • September 26, 2007 at 2:11 am

    #736273

    HI ,

    The only way that I know how to do this is as follows:

    1 return your results to a file instead of Grid.

    Or return your results to text and then copy and paste the results.

    You can then use text to columns in the spreadsheet to delimit the data.

    Thanks

    Chris

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

  • September 26, 2007 at 5:33 am

    #736309

    Change your output to Text.

    Change the options to show results as Tab-Delimited.

    Run your query.

    Copy the results.

    Paste in Excel.

    Rinse and repeat 🙂

    --------------------
    Colt 45 - the original point and click interface

  • September 26, 2007 at 3:03 pm

    #736538

    2005 solved that problem ...


    * Noel

  • September 26, 2007 at 4:24 pm

    #736549

    If you are still in 2000, check if this helps : http://dotnetjunkies.com/WebLog/dinakar/articles/136661.aspx

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

  • September 27, 2007 at 2:06 am

    #736643

    Thanks. With your help my poor brain surged into life and I sorted my problem.

    I'll write it down this time!

    :Whistling:

    Madame Artois

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply