Professional Web Applications Themes

SQL Query Output to Excel file - Microsoft SQL / MS SQL Server

I need a way to save the result of a query into an excel file from SQL query yzer. Thanks...

  1. #1

    Default SQL Query Output to Excel file

    I need a way to save the result of a query into an excel file from SQL query
    yzer.

    Thanks


    Rajesh Guest

  2. #2

    Default Re: SQL Query Output to Excel file

    The way to do this is to select the output to file. The file is a fixed
    spaced file, so you will need to use the import wizard


    --
    I hope this helps
    regards
    Greg O MCSD
    SQL Scribe Doentation Builder
    Doent any SQL server database in minutes
    Programmers love it, DBA dream of it
    AGS SQL Scribe download a 30 day trial today
    http://www.ag-software.com/ags_scribe_index.asp

    "Rajesh" <com> wrote in message
    news:phx.gbl... 
    query 


    Greg Guest

  3. #3

    Default Re: SQL Query Output to Excel file

    Greg,

    Under Tools|Options, on the Results tab, the output
    format can be changed to CSV (comma-separated values),
    which is a bit easier for Excel to p.

    -- Steve Kass
    -- Drew University
    -- Ref: 114ECB9C-0D23-4109-9639-81D5ECFB448D

    Greg Obleshchuk wrote:
     

    Steve Guest

  4. #4

    Default Re: SQL Query Output to Excel file

    Hi Steve,
    Even better!

    Greg
    "Steve Kass" <edu> wrote in message
    news:phx.gbl... 
    >[/ref]


    Greg Guest

Similar Threads

  1. Formatting Excel Output File
    By mxstu in forum Macromedia ColdFusion
    Replies: 1
    Last Post: June 17th, 08:23 AM
  2. Formatting Excel Output File
    By MillerBoard315 in forum Macromedia ColdFusion
    Replies: 0
    Last Post: June 16th, 10:54 PM
  3. Download query results to Excel file
    By JethroTull in forum Macromedia ColdFusion
    Replies: 3
    Last Post: June 3rd, 02:30 PM
  4. Replies: 1
    Last Post: July 14th, 02:34 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