Appending records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What I need to do is append new data to an existing table. There is an
existing table that has 3000 records and there is a duplicate table that has
3500 records. Each table has the same unique identifier. I know this is a
simple problem but I have not been able to append the new records from the
second table that are unique to the first table.
 
What I need to do is append new data to an existing table. There is an
existing table that has 3000 records and there is a duplicate table that has
3500 records. Each table has the same unique identifier. I know this is a
simple problem but I have not been able to append the new records from the
second table that are unique to the first table.
Click to expand...

An Append query will do the job... IF you don't inadvertantly try to
append a record which would duplicate a unique key! For instance, if
your target table has a record with 125 in the Primary Key field, any
attempt to append a record from the other table with 125 in that field
will fail (as it should; you don't want to *overwrite* data, you want
to add new data, and the primary key is by definition unique).

What specific records are failing? What error (if any) are you
getting?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top