Hi,

I'm trying to export data from SQL 7.0 to an "Excel 8" spreadsheet. I
have a DTS package that "deletes and re-creates" the table/worksheet
in the Excel file and copies data to the spreadsheet.



What I find is that if the original worksheet had 10 rows of data,
then when I run the DTS package, the newly created worksheet has 10
blank rows followed by the copied data.



It seems like:



(1) rows 1 (with column headers) isn't touched at all

(2) existing rows are cleared of its contents

(3) new data is _appended_ onto the succeeding rows



How can I get around this problem?



Thanks.