Error from Append Query

[Guest]

I am attempting to append some data fields to an existing table from a table
created from an imported Excel sheet. Basically a customer information table
and I need to append three additional fields, two tax id's and an additional
reference field. The new table and the customer table share a common key
"CustomerID". When I attempt to run the append query I recieve an error
stating none of the records are appended due to "key violations". Any
suggestions to solve this problem will be greatly appreciated. Thanks!!!

 

[tw]

if you're adding data to newly added fields than you need to use an update
query not an append query.

if you're adding more records to the existing table and the existing table
has records with key values that are the same as in the spreadsheet than you
have violated primary key rules which need that field to have unique values.

 

[Guest]

I am adding additional fields to existing records, not additional records.

 

[tw]

then use an update query not an append query

I am adding additional fields to existing records, not additional records.