I'm trying to append records from one table to another but am getting a validation rule violation error. I'm only appending one field. And the table I'm importing to has no validation rules set except for field length. None of the fields violate this length. Is there any other reason it could be failing? It's not a primary key field either, on either table.