Deleting objects using a *name* format (1 Viewer)

[bheylman]

Does anyone know if there is a command that I can use to delete all tables that contain the string import_errors? Thansk - Bruce

 

[glynch]

Try something like:

For Each tblTable in dbCurrent.TableDefs
If tblTable.Name like "*import_errors"
tblTable.Name.Delete
End If
Next

This is close but the syntax might be off, it should get you close enough to use Help to get it right.

Good Luck, Gerry