Need to delete all records in the recordset

[AshikHusein]

Is there any way of delting all data in a table through VBA instead of going to each record in the record set and deleting records individually. Would save me a lot of time if I could do this. Will apreciate your help for the above. Thanks.

 

[Mile-O]

Just make a query.

DELETE *
FROM MyTable;