append query kicks out most of my records

[Guest]

I have 1049 records to append to a table with a 3 field PK. The append
rejects 789 records due to key violations; no other reasons reported. A Find
Duplicates Wiz picks out 14 records with Field1 being duplicated. I also
create a field during this append that identifies the source;that is the
second field in the key. Even when the table is empty I get the same 1049
minus 789, so I am not duplicating data from a previous append (highly
unlikely anyway, given the nature of the data flow.)

 

[Allen Browne]

So 789 of the 1049 records you are attempting to add actually violate rules.

For example, of 2 of the records have the same value in the 3 fields of the
PK, the first will succeed, but the 2nd will fail.

For a list of where to look to find the cause of the rejections, see:
Why can't I append some records? Trouble-shooting imports
at:
http://allenbrowne.com/casu-19.html

 

[Guest]

I tried all that; I absolutely know for sure my fields are unique...guess
what it was. My field size was too short (you'd think 15 was long enough for
an ID, but these guys go on for 30 characters!), so the ID was getting
truncated, and once it was truncated...duplicates occurred )

thanks anyway!