Post reply

How do you convert in to Excel file

  • May 5, 2007 at 4:37 am

    #173251

    I have question regarding to the t-sql query.

    once i run query in Query Analyzer. once query is run how do i convert the out put in to my EXCEL file with Column header too?

    Thank You,

  • May 5, 2007 at 5:45 am

    #704501

    Set output to text and tab format*, execute query, copy and paste results.

    * Done in Tools, Options

    Far away is close at hand in the images of elsewhere.
    Anon.

  • May 7, 2007 at 1:52 am

    #704583

    Set output to grid and query options (context menu, result, grid) to include the header in copy or save.

    Cut and Paste the result-grid to Excel.

  • May 7, 2007 at 8:32 am

    #704655

    quoteinclude the header in copy or save

    Not possible to include headers in copy or save for Grid results in QA (Query Analyzer)

    Alternative to the copy and paste for Text results, you could Save As to produce a file for Excel (but beware the 'Row(s) affected' message will be included)

    Far away is close at hand in the images of elsewhere.
    Anon.

  • May 7, 2007 at 2:48 pm

    #704773

    Thanx guys. Done it... It works

    Thank You

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

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