How Do You Delete Rows In A Table Using SQL In Microsoft Access?
Sometimes, you want to delete all the records in a table without deleting the table itself. Here’s how it’s done. Open the SQL view window. Make sure you delete the pre-set SELECT clause. Type “DELETE FROM” and the name of the table with the records you want to delete. For example: DELETE FROM CustomersTable. Run the query.