okay you lost me. I get that I run the append query in the beginning and that will get the data to the table but when you say "run the append query in the macro" that's the piece that's not clear. What macro? When I run the append query currently it just appends all the data into the table meaning when I run it a second time it repeats that step. My issue is I can't have duplicate records come into the table and none of the fields by themselves are unique so when I run that append query I need it to look at each record and if it is a duplicate I don't want to be brought into my table.