Delete/Import Table Query

[Mighty]

Hi Folks,

I have an Access DB which basicallys stores a snapshot of some tables from another DB at the end of a calendar month. I have started to code a VBScript program and what I need to be able to do is delete tables from my DB and then import new ones from another database.

can I write queries to do this?

Thanks

Mighty

 

[PHV]

The sql syntax for table deletion is:
DROP TABLE TableName;

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