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 - 2006-05-25 : 11:42:04
|
| Hi i've a DTS that gets data from a excel file each day, and transform this to a access database, i only want the new data in the access database each day, so i want to delete the contents of my access database table, like truncate table in SQL, but i do not know the command any idea's ? or is it possible ? |
|
|
twhelan1
Yak Posting Veteran
71 Posts |
Posted - 2006-05-25 : 13:49:23
|
| You need a DTS step that executes a simple delete statement with no where clause i.e. delete from <your table>. Make sure that step is executed before your insert.~Travis |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-05-26 : 04:02:23
|
| Thanks TravisThis is my first time using Access and SQL. |
|
|
|
|
|
|
Truncating an Access table