delete all records

[ejmiller2]

i want to populate a table with info from a txt file...but first i want to make sure this table is blank...nothing there...i must do this before populating...i tried this...

Do Until rsPeopleNotEmailed.BOF

rsPeopleNotEmailed.MoveLast
rsPeopleNotEmailed.Delete
Loop

but it give me the eof bof error...any suggustions?..thanks

eric

 

[PaulF]

use

DoCmd.SetWarnings False
DoCmd.RunSql("Delete * From TableName&quot
DoCmd.SetWarnings True

PaulF

 

[dan1967]

Try doing this. This is a basic SQL delet command that will delete records from a table based on criteria you set. In the below example, I am deleting all of the records from my table RptTrk_Archive, which I use as a temporary holding pen for records before archiving them. The FALSE tells Access you do not want this action to be part of a transaction, which is a function to "undo" changes.

DoCmd.RunSQL "DELETE RptTrk_Archive.* FROM RptTrk_Archive", False