Ladies and gentlemen,
first I want to wish each and every one of you a wonderful and prosperous new year.
This is not really a problem. I am looking for an efficient and quick way to copy table content from one database to identical tables in another identical database.
I have two Access databases: "PTSPROD" which is production database and "PTSTEST" which is a test database both databases have 10 identical tables.
Objective: I need to erase the contents of 5 of the tables in "PTSTEST" then copy contents of 5 similar tables from "PTSPROD" into "PTSTEST".
I could mannually delete the table contents, then copy and paste, but that will be crude.
Question: How can I programatically accomplish this task faster?