How do I speed up an Access (SQL) Delete all records

[kilabyte]

I have a csv file that I download from a remote server every morning at 8am.

This is imported in access and written to an Access table on one of the servers, having first deleted the previous days version of the Access table.

The importing of the csv and then the outputting to the Access table takes less than 5 minutes, but the deleting of the records in-between from the discarded table is taking upto 50 minutes.

The table is around 55,000 records (each with 14 fields).

I am working in Windows Server 2003 with MS Access 2003.

I am using a standard Access delete query, the SQL reads as :

DELETE dbo_tbl_Ben_INV_MID_INV_DET_BEN.*
FROM dbo_tbl_Ben_INV_MID_INV_DET_BEN;
 

Any ideas how I could speed this up as this seems very slow for that many records?

[FishVal]

Hello, kilabyte.

• Does the table reside on MS SQL server ("dbo" prefix in table name)? If so, then would pass-through query work better?
• Have you tried to drop the whole table instead of deleteing records?

Regards,
Fish