Append Query

[Downie77]

I have a table where I will be loading data from excel and I have an append query to move that data to another table. Is there a way to make the append query only add the new data from the first table? Or do we need to clear out the transition table before we run the append query?

 

[boblarson]

If you have already transitioned the other data, just clear it out before adding the new stuff. That is what a transition table is for. It isn't to hang on to everything and store it twice (in it and the table(s) it has been appended to).