delete a table using ADO

[Guest]

I want to delete records in a table to make it ready (i..e, empty) for new
data to load. This table needs to be clear up everytime we want to load new
data. Do you know to do it using ADO.
Thank you for your help.Tim

 

[Allen Browne]

Try:
CurrentProject.Connection.Execute "DELETE FROM Table1;"

 

[Guest]

wow! just one line of code. It works!
Thanks a lot.
Tim