>Interesting idea. Where is the clean (empty) structure before it is called. Is it in another folder or is it in the production folder but named something different.
Renaming tables would cause you trouble with the links between database and tables, and with referential integrity.
I suggest another folder, same names for database and tables.
> Once appended FROM, how does it replace the production files.
The outline of the process is more or less like this:
Copy the clean, empty database to a temp folder. After all, you may have to use it more than once.
APPEND FROM - from the current data, into this temp folder.
Copy the temp folder to the production data, replacing the previous version.
>Are the production tables renamed before the append FROM.
No, I suggest you don't change the names of ANY table. Just work with different folders.
Note that several things can go wrong; you may need to include lots of error handling. Like, a table (especially in the production data) can't be opened because it was erased, because the index (CDX) was erased, because it is no longer linked to the database, etc.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)