Replace Excel worksheet contents from SQL Query via DTS

• Neil-222145

  Old Hand

  Points: 347

  More actions

  May 10, 2006 at 8:36 am

  #168282

  If I run a query and drop the results into c:\file.xls then the worksheet in the XLS file just keeps growing (appends data not replaces data).

  I cannot see how to remove the entries and replace with current query values so that the excel file only has the results of that query just run.

  The excel file has formatting that I need to keep too, so creating a CSV file won't help.

  TIA

  Neil.

• Luke L

  SSC-Dedicated

  Points: 35547

  More actions

  May 10, 2006 at 2:12 pm

  #637109

  Have a look at the below article.  Specifically where it talks about the drop table command instead of delete.

   

  -Luke.

  http://www.sqlservercentral.com/columnists/jsack/capturingtheerrordescriptioninastoredprocedure.asp

  To help us help you read this[/url]For better help with performance problems please read this[/url]

• Neil-222145

  Old Hand

  Points: 347

  More actions

  May 11, 2006 at 2:29 am

  #637175

  Thanks Luke, this looks just what I was after.

  Neil.