Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Location
    Big City
    Posts
    62

    Unanswered: DTS package to overwrite the existing Excel

    Hello,
    Is there are a way to set up a DTS package
    to export data to an Excel format, overwriting or deleting the existing Excel file.

    Thank you,
    Y

  2. #2
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    there r a few tricks for this.
    (1) add a ActiveX or SQL task before the export task to delete existing xls and copy a blank xls file in the same name
    (2) export as CSV file and that can be opened with excel directly (can aslo change the extension to xls)
    (3) write script to delete rows from existing excle file and then append data.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •