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?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Delete table and import data problem
- Thread starter spiral123
- Start date
You can easily write a simple function to return whether a given table exists, as per the code at
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.
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.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
