I am specifically interested in help regarding what causes a key violation. After numerous attempts, my append query continually fails as a result of this incidious key violation. Many, many trials at resolving the violation have failed indicating I am clearly on the incorrect path. Might someone offer insight as to the cause of this problem as I feel confident there is something basic I am missing?
Here's the background:
I am attempting to append a table with data from Excel. I created a table by importing the data with the "Get External Data" tool. The new data table has 56 records each with 33 fields.
I made certain all the fields I want to append (I am not appending all the fields in the recipient table) are the same Data Type, down to the specific field properties, in the donor and in the recipient tables. Both tables have independent primary keys with an AutoNumber data type. In the append query, I did not include either primary key per the action query instructions on the MS website. This was all to no avail.
Every time I attempt another iteration, I get the same error: "... and it didn't add 56 record(s) to the table due to key violations...". I always choose not to run the action query anyway.
Signed,
Totally Frustrated oleBucky