I am trying to append data from one table to another. I keep getting an error that reads:
" Microsoft Access set 0 fields , to Null due to a type conversionfailure, and it didn't add 0 records to the table due to key violations, 0 records due to lock violations, and 44 records due to validation rule violators."

I have no validation rules set. Please Help.

Check whether the fields in the source enumeration and destination enumeration are in the proper order and properly aligned. If field X is a text field in the source but an integer in the destination, you have violated the "validation rule" for data type.