SQL select statement results to XL file

  • I am executing a script to get the required report in prod server. How to get that result into XL file?

    Please let me know the process, I am using sql 2005 version

  • What do you mean by "XL file"?

    Is it a typo meaning XML structure or do you want to store an "eXtra Large" file?

    If the former, please search for "XML Workshop" on this site. This will give you a list of articles by J. Sebastian covering a lot of questions regarding usage of XML.



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • lmu92 (11/10/2009)


    What do you mean by "XL file"?

    Is it a typo meaning XML structure or do you want to store an "eXtra Large" file?

    If the former, please search for "XML Workshop" on this site. This will give you a list of articles by J. Sebastian covering a lot of questions regarding usage of XML.

    I need a select statement result to microsoft office XL file for reporting purpose

  • There are a few ways you can do this.

    1. In Excel you can connect to a database and have the query come back to a worksheet.

    2. If it is a 1 time thing, you can use the data import/export wizard. Right click on the database you are pulling information from and the Import/Export data option comes up. You select your database as the source, tell it you want to use a query to specify the results, and then tell it to go to excel as the output.

    3. If it is a repeating task, setup a report in reporting services. Your users would be able to export into a csv file from the report.

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

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