This usually happens when you try to insert Text into a Numeric field.

To Resolve...

Remove offending Text OR just leave it alone because basically Access simply set the fields to Null.

and it didn't add XX record(s) to the table due to key violations,

Meaning...

1. There is a field or two that have been formatted to except a certain set of data and the data you are trying to

insert in the field(s) cannot go in because it will violate that format. Example…

Field1 can only accept values A and B. But you trying to append C to it. In this case there are 21 records that won't

append because of this.

Action Query Errors... What do they mean?

"Microsoft Access can't append all records in the append query…

Microsoft Access set 0 field(s) to Null due to a type conversion failure,

Action queries Use Transaction’s. Having this feature set to Yes (see A) causes the results to be stored in a cache, as a single transaction, until you confirm, by clicking Yes. When it is set to No the results are immediately written to the table/field because it handles the change as a single action at a time.. This does cause your query to run faster, though I’ve noticed very little difference.

However, having it set to No means even if you click "No, I didn’t mean to do that" does not save any of the changes the query has already made even though the transactions were being processed separately.

The difficult I do immediately, the impossible takes a little bit longer.