Can't append all the records in the append query

[Payal Patel]

Hi,
I am trying to append records a query in a table. but I keep recieving the error "can't append all the records in the append query" due to validation rules. What does this mean and how do I resolve this? Thank you

 

[boblarson]

It could mean you are trying to insert a number where it is an autonumber, a null where nulls are not allowed, an empty string where zero length strings are not allowed, etc.

 

[PNGBill]

You may need to provide some info on your query fields and table fields.

One way to find the error is to reduce the number of fields being appended. Get it working and then add fields and test until you find the field that is causing a problem.

Also, if the table has an autonumber for it's primary key, ensure you are not trying to append data to this field as the table will create this as required.

Check date to date, text to text and number to number field. maybe you are appending text to a date field.

 

[jdraw]

Could you post your table(s) structure and the sql for the append query?

 

[gemma-the-husky]

it could even mean that you have duplicates in the data you are trying to add.