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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

join keeps cascading 2
Update or Append Query in Access 2003 2
Help with append query 4
UnMatched Query 2
append query 1
Append with Sub query 2
SQL Statement Insert Into 5
Have both records from two queries/tables under one Query without related fields. 0

Back
Top