Output in excel file format

• M&M

  SSC-Insane

  Points: 21700

  More actions

  September 26, 2008 at 4:19 pm

  #127813

  Just curious, is it possible to get sql output directly onto a excel file using SSMS. I need it in a presentable format. Please share your inputs.

  Thanks.

  M&M

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  September 26, 2008 at 5:23 pm

  #878010

  You could use OPENROWSET in your T-SQL statement which would write your output to an Excel workbook

  An example is:

  INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\MSSQL\Test.xls', 'SELECT * FROM [Sheet1$]')

  SELECT * FROM Keywords

  check BOL for examples

  An excellent article with sample code and a good explanation is:

  http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

  Hope this helps.

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]

• M&M

  SSC-Insane

  Points: 21700

  More actions

  September 26, 2008 at 5:38 pm

  #878012

  Oh. Thank you. I didn't know I will get an answer so quickly.

  Thank you very much.

  M&M