I had excel sheet has Data table 1000 row * 210 column.
First column is Symbols (strings) and all other row is empty.
I used DTS package (column copy) from the SQL2000 DB to Second column in the excel sheet 1000 records per that column.
It seams the DTS appended the data to the second column, because it starts put data at cell B1001 where the first column data ends?
Then I delete those entire cell and run the DTS package again, it put the data starting at cell B2001.
For some reason the DTS still keeping some pointer to append the data.
I don’t want to append data. I want to overwrite the columns with new data.
Note:- using fresh excel file will not help, because I need to add data to columns 1 through 210 sequentially every 2 minute.