Faster deletion of all records in table?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Don Wiss - 05 Nov 2005 02:19 GMT

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).

Reply to this Message

Ken Snell [MVP] - 05 Nov 2005 04:14 GMT

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.

Signature

Ken Snell
<MS ACCESS MVP>

> 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
[quoted text clipped - 7 lines]
>
> Don <www.donwiss.com> (e-mail link at home page bottom).

Reply to this Message