Appending Data and/or Required Field

[Guest]

My objective is to append data from one table to another table in a different
database. I was able to get it so that 1951 records were appending but it
had key violations. I deleted every primary key in both tables and I still
kept getting that violation.

So, then I tried to cut and past the data from table to another, but the
message that I could not copy information because a required field was
required in another column. I went to every table in both databases to make
sure that there were no "required" fields, but the message keeps coming up.
How do I remove a "required" field, other than in the table in design view.
I have already done that, but still can't make the message go away and copy
the data. Help. Thanks.

 

[Allen Browne]

Typically, when some records don't make it, you end up with a table called
"Paste Errors" or "Import Errors". The records in that table will probably
give you the clue as to what the issue is.

Other than the Required property of the field, you could look at the
AllowZeroLength property. If it is set to No (as it should be) in the target
database, but Yes in the source database (generally a very bad idea), it may
be the source of the issue.

You can also get a key violation if your target table has a relationship to
another table, but the value you are attempting to import is not present in
the lookup table.