Whenever I do an import into SalesLogix I put all my source data into a staging database in SQL Server. This allows you to work with your data in a common place and massage & group data via SQL Views and provides a common place to work with your source data no matter what format it was in (CSV, Excel, Access, AS400, dBase, etc). Those people who have attended my TSQL/DTS training will understand what I am talking about here 😉
When testing my import I often have the need to dump all data from my staging database so I can start out empty again and test the entire import (including the loading of the staging database). I use the following statement to truncate all tables in my staging database that are owned by the SYSDBA user (Since the purpose of the staging database is to prep your data for an import into SalesLogix, I tend to create all tables to be owned by the SYSDBA user)
exec sp_MSForEachTable 'IF ''?'' LIKE ''%SYSDBA%'' BEGIN PRINT ''Truncating ?'' TRUNCATE TABLE ? END'
You can easily add additional tables or conditions of tables to exclude to the statement to fit your particular needs.