Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2008-10-02 : 12:23:16
|
| Hi i need to produce a report each month in excel. I collect the data from a table in SQL, my problem is that i want to truncate the excel report each time i run it. Is there are way in sql for it to references a tab in excel and delete its contents ?Or maybe am going about this the wrong way ? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-02 : 12:57:16
|
| Yes you can do it:While using Export Import Wizard, You can tick Drop and recreate Destination table on Edit so you will get new one instead of appending |
 |
|
|
|
|
|
Truncate report from DTS package