Delete table and import data problem

[spiral123]

I have to replace tables from one database to another on a daily basis. The problem is if there is an error on the import the macro has a problem running when it hits the delete part. I need to check for the existence of a table before running the import feature, or just overwrite the table. any suggestions?

 

[mp9]

You can easily write a simple function to return whether a given table exists, as per the code at

http://www22.brinkster.com/accessory/tables/001.shtml

You can then use this function in the condition column of your macro action, i.e. if the function returns true then do the delete.