G
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!!!
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!!!