dndaughtery
Programmer
I have a dts package that creates an excel file but it appends to the existing file instead of overwriting it. How can I get it to overwrite instead of append.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How 2 set DTS to overwrite an existing xls file
- Thread starter dndaughtery
- Start date
- Status
jbenson001
Programmer
You will probably need to use the File System Object in an Active X Script.
JIm
JIm
- Status
Similar threads
- Locked
- Question
- Locked
- Question