Faster deletion of all records in table?

D

Don Wiss

When I import new data for a table, I first like to delete all existing
records. But opening the table, pressing Ctrl-A, then the delete key, will
take a really long time if many records. Is there a faster way?

It is not clear to me that if I import data to an existing table with data
that it will always replace and not append. It seems I am not always asked
that question.

I am using Access 2002.

Don <www.donwiss.com> (e-mail link at home page bottom).
 
K

Ken Snell [MVP]

Run a delete query. Create a new query based on the table, change it to a
Delete query (Query Type icon on tool bar), drag the .* field to the grid,
and save it with some name.

Then just run that query. It'll run much faster than the manual select and
delete method.
 
Top