DTS to Excel (replace existing rows)

Hi,

I am using a DTS package to output a view to a pre-determined Excel file. Currently it just adds the output to the bottom of the current table in excel but i would like it to delete the contents of the worksheet before adding the new rows.

Any help is much appreciated.

Thanks

Greg

So in other words, if a row already exists update it, otherwise insert. Is that correct?

If so, read this: http://www.sqlis.com/default.aspx?311

-Jamie