Excel File Genration

• anup_snwn

  SSC Enthusiast

  Points: 174

  More actions

  December 12, 2008 at 6:00 am

  #195024

  hi friends

  i want to create excel file from sql server 2005

  on any qry excution or stored procedure excution

  thanks

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  December 13, 2008 at 6:45 pm

  #912144

  Select Results to file option under Query-->Results to-->Result to file in ssms. This works gud with csv files.

  You can also use openrowset for this.

  MJ