deleting imported errors table 1

[balllian]

After importing a text file into access. Access is creating the 'combined_Importerrors' table.

Is there anyway of deleting this particular table completely without leaving data definitions of the table within the database.

I want to do this via a macro if possible??

 

[PHV]

You may execute this action query:
DROP TABLE combined_Importerrors;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[balllian]

Is it possible to extend this to the do the following

delete two tables in one go. and create a new table by renaming an existing table (combined1) into one of the ones i have deleted (combined)

The reason behind me asking this is as the table im deleting has approx a million records, what my current practise is to to run an update query to delete all the records. it might be quicker to delete the table and recreate it by renaming another table.

Would this be better??

 

[balllian]

i should have added also how do i do this?? it must be possible??

thanks in advance for any help u can provide with this.