can't append all the records in the append query.@|9 set |1 field(s) to Null due to a type conversion failure, and it didn't ...

|9 can't append all the records in the append query.@|9 set |1 field(s) to Null due to a type conversion failure, and it didn't add |2 record(s) to the table due to key violations, |3 record(s) due to lock violations, and |4 record(s) due to validation rule violations.Do you want to run the action query anyway?To ignore the error(s) and run the query, click Yes.For an explanation of the causes of the violations, click Help.@@21@1@10020@2