Appending sounds like it will add all the records to the table and leave the old one.
As I said, you will be running a DELETE command to delete all the records out of the table before you add the new records into it. Maybe an example will clarify it.
Let's say you created a table called
MyTable that you want to add these records from your Append Query to this table. The first time through, let's say it adds 100 records.
Now, the next time around, let's say your Append Query has 200 records to add.
If you create the Macro that I described that has two steps in it, it will do the follow:
1. Run the DELETE command to delete all the records currently in
MyTable. So when this step completes, there will be zero records left in
MyTable.
2. Run the Append Query. This will add the 200 records to
MyTable.
So when all is said and done, all you will have is the 200 new records. You will NOT have any old records. The DELETE command is deleting all old records from your table before using the Append Query to add new records to it.
That is what you want, right?