I am trying to transform a formatted text file into an excel table using
an excel connection to the excel file. This works correctly once the
table has been created for excel by the dts transform. The real issue is
that I would like to reuse the created excel table for different input
files. A new file merely appends data to the existing table. The
transform creates 2 objects (Table and Table$). I can perform TSQL
commands on both objects except when I try 'DELETE TABLE$' I get a
message "deleting data in a linked table is not supported by this ISAM".
The command 'DELETE TABLE' is executed without error but the table in
excel is not cleared. Does anyone know how to do this?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!