Sql Query output in excel format

• pankaj.kuchaliya

  SSC Eights!

  Points: 944

  More actions

  October 5, 2010 at 4:00 am

  #227582

  Hi,

  I have some doubt about , how to save the query output in excel file.

  suppose when i fire this query from query window.

  select 1 as 'd','pankaj' as 'name'

  then the result will be saved in excel file .

  is it possible , how can i do it.

• drew.allen

  SSC Guru

  Points: 76944

  More actions

  October 5, 2010 at 6:26 am

  #1231623

  You can save a grid as CSV or you can select the entire grid and paste it into Excel. There is a setting in options that will copy the field names as well.

  Drew

  J. Drew Allen
  Business Intelligence Analyst
  Philadelphia, PA

• g33kspeak

  Mr or Mrs. 500

  Points: 531

  More actions

  October 5, 2010 at 8:16 am

  #1231727

  You could also use SSIS to export the data by query to an Excel file. Just right-click on the database and select "Tasks" then "Export Data...". That will bring up a Wizard you can walk through and push your result set to an Excel file.

  Not as quick as the copy/paste method though!

• parthi-1705

  SSCrazy Eights

  Points: 9277

  More actions

  October 5, 2010 at 1:16 pm

  #1232024

  pankaj.kuchaliya (10/5/2010)

  ---

  Hi,

  I have some doubt about , how to save the query output in excel file.

  suppose when i fire this query from query window.

  select 1 as 'd','pankaj' as 'name'

  then the result will be saved in excel file .

  is it possible , how can i do it.

  Hi

  In grid there will be results to text,results to grid,results to file use have to choose results to file in this case to store what ever format u need, then execute it and save it in your desired name.

  Thanks

  Parthi

  Thanks
  Parthi