Post reply

Export query results to Excel

  • November 2, 2005 at 11:30 am

    #88471

    How can I export the results of a query done in SQL Query Analyzer to an Excel spreadsheet.  I found some suggestions for using DTS to do this but I can find no examples of how to set this up.  Can anyone point me to an example?

    Thanks,

    Dave

  • November 2, 2005 at 11:49 am

    #601945

    Give this a read

    http://www.sqlservercentral.com/columnists/yShlafman/thebestkeptsecretaboutsqlqueryanalyzer.asp

  • November 3, 2005 at 10:28 am

    #602187

    Go right click on the Table you want to export the data to Excel, Choose All Tasks -> Export Data. You see the DTS Import/Export Wizard.

    Click Next, you can see the "Choose a Data Source" section already filled up, click next, you will see "Choose a destination" section. In the destination dropdown, choose "Microsoft Excel"and give a filename. click Next. Choose Copy table and views form data source and click next. check the Source table you want and destination. click Next. Check Run Immediately and go next. Make sure to Preview the information and click Finish.

     

    Hope it helps.

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

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