Key Violation Table -Where is it?

I've imported and converted an 11-column Excel worksheet into an Access 2003
db as its own table (tbl_XLS) with a single PK field. As a result of using
an Append Query to add the 1753 records of tbl_XLS to a similarly structured
table (tbl_ACC) of 4890 records, I received notice of 264 records not being
appended due to "key violations'. Of the 12 fields in it, 'tbl_ACC' has an
AutoNumber PK field and one indexed field matching the design of tbl_XLS's
PK field.
Though frustrating, I don't mind receiving the error message as much as not
receiving a "tbl_Key Violation' after clicking the"Yes-Proceed with the
Append Operation" button. I recall from using Paradox in the early 90's, it
would create a 'Key Violation' table - I wonder why Access doesn't- it
creates an Import Error table, a KV table couldn't be that much more
difficult to produce. I thought about clearing the indexes and PKs in both
tables and then running a 'Duplicates Query' to find the 264 culprits, but
that seems a 'clumsy'.way to do it. I also thought the fact that tbl_XLS
did not have an AutoNumber field may be the problem, but with 1489 records
being appended, that could not be the case either.
After searching the NG Forum with no answer, my question is if anyone has
found a way to produce a KV Table they would be willing to share or some
other way to find the 'offending KV records?

Thx for any help...
Earl


.

Relevant Pages

  • "no records" message for append query
    ... I'm trying to add an error message to an append query when there are no ... the subform when there is a template of parts for these two fields. ... Private Sub Command24_DblClick ...
    (microsoft.public.access.formscoding)
  • Re: Autonum problem
    ... Does the append query contain the autonumber field as one of the output ... is an indexed field in table1 that will not allow duplicates, ... The append query kept trying to reuse a deleted autonum and would ...
    (microsoft.public.access.tablesdbdesign)
  • Error trapping on a form
    ... Private Sub cboStdResponse_NotInList(NewData As String, ... Dim stNewValue As String ... suppress error message ... >append query runs fine and adds the data to the table. ...
    (microsoft.public.access.forms)
  • Re: "Indexed or Primary Key cannot contain a Null value" / Autonum
    ... post the exact error message you are receiving. ... Tips for Access users - http://allenbrowne.com/tips.html ... or in the AutoNumber field if you open the table in design view? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Append Query & Linked Tables
    ... tblPlatRevisions_ID (this keeps up with any plat revisions by the county ... The append query just pulls the tblExcelImport into tblLotInformation. ... I am not trying to append an autonumber field. ...
    (microsoft.public.access.queries)