Deleting All Records from many tables

[Dbless]

I have 50 tables that need to be cleaned before importing all new data. I'm using an SQL "Delete * from tablename" and executing it through a macro. Keep getting out of disk space and/or memory error. My machine has enough memory and disk space. How can I remove all the data from the files successfully?

Pre-thanks

 

[FancyPrairie]

If this is a one time import, why not create a new database, import the tables, but select the option "Import Table | Definition only".

Or you could do a copy/paste in the current database and paste with the "Structure Only" Option checked.