Append query - key violation question

[Guest]

I'm having a tough time with a key violation error.

Background: I'm taking data from a table, that has about 6000 records, and
trying to append it to another table. The primary key in the destination
table is a autonumber that I am not importing into the table (it assigns
itself with every new record). There is no primary key in the source table.

The warning tells me there are only 2 records that weren't appended due to a
key violation. There are actually 8 different records that are duplicated in
the source database, (I need to fix that) but if that was a problem, shouldnt
I get 8 records could not be appended? There is also an "id" number for each
record (they're students) that I append to help match a student currently in
the db. This id is not a primary key in either table, nor do I want it to
be- a student can have multiple records appended in the same table.

I guess the first thing I need to do is eliminate the duplicate record(s)
and make sure that isn't causing something goofy, but even then, how do I
delete only 1 of the records that is a duplicate in access??? I know how to
identify both of them and take them out of the table- I just don't know how
to take just 1 out.

Anyone know how you can identify the offending records in an append error?

thanks

 

[Guest]

Use the find duplicate query wizard and examine the records. Then decide if
you want to delete, not append, or use a different number for primary key so
as to append.