I was thinking of PACK and not ZAP!
As others have said, you can use TRUNCATE TableName but it won't work if the table has foreign keys. In this case, you need to use DELETE FROM TableName (which is slower because of the log).
>Isn't there a way to delete all records from the database in one shot?
>what about th rest, is it possible to schedule a import routine frm an excel file?
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com