Post reply

How to truncate an excel file

  • August 6, 2009 at 1:19 am

    #1035210

    Hi,

    I have two ideas for solutions to this problem.

    First, the complex one: you could write a script task that uses the excel object model to clear the rows before appending new rows

    Second, the easier one: just save an empty excel file beneath your destination file. Before inserting records into the file (i.e. before opening the connection), just use the file system task to copy the template over the destination file. Noew your destination file is empty...

    WM_HOPETHATHELPS

    Guenter

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply