Append Query

[Guest]

I have two tables.
Table A has 349,353 records.
Table B has 377,787 records.
I need to add the 28, 434 records that are not in table A but are in table B.
Table A and B have a unique 6 digit number as its primary Key.
When I attempt to run an append query from B to A, I get an error message
stating it did not add 28, 434 records due to Key Violations.

Sorting the unique 6 digit numbers tells me right off the bat that there are
some in B that are not in A, yet when I attempt an append query, it tells me
there are Key violations.
I even selected on specific record whose 6 digit number I know is not in
table A...and it still states that it didn't append due to a Key Violation.
Are there "invisible" keys Access puts in place that might be causing this?

TIA
Antonio

 

[pietlinden]

I have two tables.
Table A has 349,353 records.
Table B has 377,787 records.
I need to add the 28, 434 records that are not in table A but are in table B.
Table A and B have a unique 6 digit number as its primary Key.
When I attempt to run an append query from B to A, I get an error message
stating it did not add 28, 434 records due to Key Violations.

Sorting the unique 6 digit numbers tells me right off the bat that there are
some in B that are not in A, yet when I attempt an append query, it tells me
there are Key violations.
I even selected on specific record whose 6 digit number I know is not in
table A...and it still states that it didn't append due to a Key Violation.
Are there "invisible" keys Access puts in place that might be causing this?

TIA
Antonio

use an outer join (use the Find Unmatched wizard if you want). Then
append those that are not already in the destination table.