Deleting all records in a access database table from Excel

I cant seem to find the code from anywhere so hopefully somebody can help me. All i want to do is delete all records in a table using vba from excel

The code below opens up a table and inserts the data from excel

Please Login or Register  to view this content.

Ive included the area where i want to delete the records in the above code. As in theory, it will easier to update the table by just deleting all the records and resubmitting all the data again.

Anyone know how to do this?

Many Thanks

Dave

This example uses an SQL command to delete all records from the Computers table in an Access database called Test.mdb.
Requires a reference to the ADODB library (Tools>References)

Please Login or Register  to view this content.