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

J

JimMurray

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
 
M

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
 
Top