Export data from a sql table to excel sheet

• bommadevara_ravi

  Newbie

  Points: 5

  More actions

  April 13, 2009 at 7:49 am

  #72006

  I am having excel sheet template which contains column names as headers.

  I want to export the data from a sql server datbase table to a specified excel sheet without using DTS or SSIS or script which should use linked server.

  Please provide me the best solution at the earlest.

  Thanks in advance.

• souLTower

  SSCarpal Tunnel

  Points: 4026

  More actions

  April 13, 2009 at 12:45 pm

  #976821

  Look into OPENDATASOURCE in Books Online. That should get you started