Validation Rule Errors

[Guest]

Could there be a violation of your primary key? In other
words, do the records you are trying to append to the
table include a key that already exists in the orginal
table?

Hope that helps!
Just an Access user trying to help,
Sue

-----Original Message-----
I'm trying to write an append query using two tables

with IDENTICAL fields (the types and other properties are
the same). I'm appending the records in one small table
to the records in a much larger table. The smaller table
was created by copying ONE record from the larger table
to Excel. I then used that Excel file as a template to
populate the records for the smaller table. I then
imported the Excel file into Access. I've tried the Help
function (which wasn't much help, obviously!) Does anyone
else have this issue?????? If so, how'd you deal with it?

 

[Guest]

I may have figured it out...the table I was appending to had a switch which did not allow a zero-length string. Apparently, when I imported a blank field from Excel, it assumed it was a zero-length string. I simply switched it to yes and that worked. Anyone know why this switch is important????