I am trying to import information into an excel
spreadsheet using SQL 7 and DTS. I have it successfully
working but want to programmatically delete certain rows
of information from the excel sheet before doing the
import (due to the fact that it appends the info as
opposed to overwrites it). Is there an easy way to do this
since all of the Q articles I've read don't seem to say
that this can be done (in fact some say the opposite). If
using active x, everytime I tried to run it it freezes my
machine. I'm guessing the code I threw together was wrong.
Anyone have any idea since I'm relatively new to DTS on
how to script a select and delete of rows from am excel
sheet. Would it be easier to create a macro to do this and
then call the excel macro from DTS? If so any idea on what
the code would look like. Thanks