I get this error message when I run a make table query. The message is very generic. I ran for two periods (Dec-08 and Jan-09) I only get the error message in Jan data.
I am not able to paste the long error message from MS Access in here so I am going type it out....please see below:
Microsoft Office Access can't add all the records in the update or append query.
It set 3 field(s) to Null due to a type conversion failure.
A type conversion failure is caused when the data in one or more fields doesn't match the DataType or FieldSize property in the destination table. For example, leaving blank fields in a Yes/No field or entering text in a numeric field will cause this error. Do you want to ignore the errors and run the update or append query anyway? To ignore the error(s) and run the query, click Yes.
I am not able to paste the long error message from MS Access in here so I am going type it out....please see below:
Microsoft Office Access can't add all the records in the update or append query.
It set 3 field(s) to Null due to a type conversion failure.
A type conversion failure is caused when the data in one or more fields doesn't match the DataType or FieldSize property in the destination table. For example, leaving blank fields in a Yes/No field or entering text in a numeric field will cause this error. Do you want to ignore the errors and run the update or append query anyway? To ignore the error(s) and run the query, click Yes.