Error in Append Query Access?

Question

Microsoft Access can't append all the records in the append query. Microsoft Access set 0 field(s) to Null due to a type conversion failure, and it didn't add # record(s) to table due to key violations, 0 record(s) due to lock violations, and 0 record(s) due to validation rule violations.

Why do I got this error? How can I fix them? Thankx.

Answer 1

Did you look in the error table to see if you could figure out what's wrong with the records that weren't appended? A likely cause is that you have a non-duplicate key field and duplicate data in those records.

Answer 2

That means that the table that your adding to already has that number in the the key field, or your trying to append data to that tables that has null values in the field that is being transferred into the key field.



Have a look on the table and sort ascending on the field that is going into the key field you may well see blanks.



or check to make sure the filed you are using to populate the key field does not have a number or ID that is not already in the table your appending to.

Answer 3

The problem is that seLECT is not a valid name - most DBMS ignore case, so it thinks your table name is the start of another select statement. Never, never, NEVER give a table or column a name that could be confused with a keyword.