Export data from SQL Server to Excel without using SSIS or DTS

• muthukrishnan.e

  SSC Veteran

  Points: 294

  More actions

  April 10, 2008 at 10:44 pm

  #91809

  Export data from SQL Server to Excel without using SSIS or DTS

• Amol Mitkari

  Grasshopper

  Points: 18

  More actions

  April 10, 2008 at 11:54 pm

  #801285

  hi,

  This is possible using sp_addlinkedserver. You just need to linked to excel sheet and using DML's or any other SQL command.

  You will get exact syntax from follwowing sites;

  http://support.microsoft.com/kb/306397/EN-US/

  http://support.microsoft.com/kb/321686

• jezemine

  SSCrazy Eights

  Points: 8059

  More actions

  April 11, 2008 at 12:04 am

  #801292

  you could use bcp to export to csv, which excel can handle no problem.

  ---------------------------------------
  elsasoft.org