Access/SQL Database - Purge SQL tables to import fresh data

[Guest]

Is there a quick way to purge the SQL data? Doing a delete from the Access
front end is slow and painful. Do I go into Enterprise Manager and drop the
table?
Help please

 

[Rick Brandt]

Is there a quick way to purge the SQL data? Doing a delete from the
Access front end is slow and painful. Do I go into Enterprise Manager
and drop the table?
Help please

Use a passthrough query and use...

truncate table TableName

....instead of a delete statement. The latter is a logged update whereas
truncate is not and should be virtually instantaneous.

 

[Mary Chipman [MSFT]]

Use a pass-through query instead. "Delete from tablename" will do the
trick. If you're OK with a non-logged operation, use the T-SQL
"Truncate table" command, which is even faster.

--Mary