Can you create an append query that will write the records to the table? If so, do that and in design view of the table, select one or more table fields for which you can create a unique index. You can create one index or a composite index. In the first case, one field cannot have more than one row with the same value (such as OrderID). In the second, you might allow two divisions to have the same order id, but as a pair they can still be unique. In a 2 field composite index, this would be allowed because taken as pairs, they are unique.
DivisionID |
OrderID |
ABC |
123 |
ABC |
456 |
DEF |
123 |
DEF |
456 |
Once you have that created, I presume you'll use macros to append the records. You'd turn off warnings at the start, append the records, and turn warnings back on. Thus there'd be no system message saying duplicate records are not allowed, and the process will append those that don't violate your index rules. The rest will be ignored.
The alternative of course, is to use code. I'll bet there are hundreds of code samples already posted on the web for this, but we can probably help with that too.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.