Apend table problem

  • Thread starter Thread starter Min
  • Start date Start date
M

Min

Hi, 2 tables have the same structure, each contains an auto number field.I
need append table1 to table2, but not success. The error message is Key
value conflict. Actually, I did not include the key field in the append
query. What's wrong?

I modified table2, change the auto number field to Long, add another auto
number field with different name, Then I do the append query again, but the
error message is the same as before.

What can I do to merger these 2 tables?

Thanks!
 
Hard to say without the SQL statement, but it could be something besides the
Primary Key field that is causing the problem. Do you have indexes on other
fields in the table that accept only unique values. IF you do and if there are
duplicate values between the two tables, that can cause an error that is a Key
Value error.
 
Back
Top