export to excel file

• elham_azizi_62

  SSCertifiable

  Points: 5095

  More actions

  February 5, 2011 at 7:30 am

  #244718

  hi all.

  i have table that store excel files to varbinary column,now i want export this data from table to xls file in hard drive.how can i do?pleas give me code sample that do this.

  thanks

• danschl

  SSCertifiable

  Points: 5770

  More actions

  February 14, 2011 at 2:03 pm

  #1286746

  need a little to be more info for code examples

  but you can setup a linked server to excel on the local drive then do normal insert into