Quick way to emply tables from VBA ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David - 23 Jan 2004 15:36 GMT

What is the best way to empty several tables in VBA. I'm writing a conversion routine and need to do this when I do a rerun.

Reply to this Message

Allen Browne - 23 Jan 2004 15:42 GMT

Supply your table names to this kind of routine:

Dim strTable As String
Dim db As DAO.Database

strTable = "[MyTable]"
dbEngine(0)(0).Execute "DELETE FROM " & strTable & ";", dbFailOnError

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> What is the best way to empty several tables in VBA. I'm writing a conversion routine and need to do this when I do a rerun.

Reply to this Message