Professional Web Applications Themes

Easiest way to copy column names for excel. - Microsoft SQL / MS SQL Server

Is there a way to use the copy/paste feature to export the entire result set from Query yzer to Excel so that it includes the column names as well, without exporting to csv first?...

  1. #1

    Default Easiest way to copy column names for excel.

    Is there a way to use the copy/paste feature to export the entire
    result set from Query yzer to Excel so that it includes the column
    names as well, without exporting to csv first?
    Random Guest

  2. #2

    Default Re: Easiest way to copy column names for excel.

    Doesn't work for me. No columns headers.

    Regards
    Nikola


    "sampangi" <com> wrote in message
    news:#phx.gbl... 
    >
    >[/ref]


    Nikola Guest

  3. #3

    Default Re: Easiest way to copy column names for excel.

    Nikola,

    There is a checkbox for the column headers that must be
    checked in Tools|Options|Results Tab.

    You can Select All, Copy, then Paste the results into Excel, or
    you can save the results as text and the headers will be there.

    Here is what I get for

    select top 10 * from Northwind..[Order Details]
    after setting the output to tab-delimited and checking
    the column header box. Are you saying that you do
    not get the first row?


    OrderID ProductID UnitPrice Quantity Discount
    10248 11 14.0000 12 0.0
    10248 42 9.8000 10 0.0
    10248 72 34.8000 5 0.0
    10249 14 18.6000 9 0.0
    10249 51 42.4000 40 0.0
    10250 41 7.7000 10 0.0
    10250 51 42.4000 35 0.15000001
    10250 65 16.8000 15 0.15000001
    10251 22 16.8000 6 5.0000001E-2
    10251 57 15.6000 15 5.0000001E-2

    -- Steve Kass
    -- Drew University
    -- Ref: 3D397B1F-326A-4282-B2E5-46E9FA46A672

    Nikola Milic wrote:
     
    >>
    >>[/ref]
    >
    >
    >
    >[/ref]

    Steve Guest

Similar Threads

  1. Getting column data without column names
    By Jared@Itron in forum Coldfusion Database Access
    Replies: 4
    Last Post: January 18th, 09:26 PM
  2. counting column and getting column names
    By dduck1934 in forum Coldfusion Database Access
    Replies: 0
    Last Post: May 24th, 02:05 PM
  3. collumm names from DB to Excel
    By fluiter in forum Coldfusion Database Access
    Replies: 2
    Last Post: February 28th, 05:14 PM
  4. Replies: 6
    Last Post: October 29th, 12:01 AM
  5. No column names
    By Vesna Martinovic in forum IBM DB2
    Replies: 0
    Last Post: July 3rd, 07:45 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139