Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740

    Unanswered: copy/paste grid from QA - no field names!

    for debug purposes i tried to copy paste some Query Analyser output into Excel... the data pastes fine, but i can't get the field-names to copy/paste.

    is there a trick?

    izy
    currently using SS 2008R2

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Not by itself...

    YOu could save it as text...you get the column names that way...

    Or you can Go

    SELECT 'Col1', 'Col2', 'Ect'
    UNION ALL
    SELECT Col1, Col2, Ect
    FROM your Table
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    text! stupidly simple really.
    thanks for the help,

    izy
    currently using SS 2008R2

  4. #4
    Join Date
    Mar 2003
    Location
    Indiana, USA
    Posts
    100
    Try results to Text & Tab delimited.
    Under Tools --> Options --> Results.

    It works OK for me.

    Tim S

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •