ERROR: Internal : Could not execute code stage because exception thrown by code stage: Data type mismatch in criteria expression.

[SourabhSharma]

HI all,

I am using oledb to update the records in excel sheet using update query. it was working fine.

but now it's throwing error: ERROR: Internal : Could not execute code stage because exception thrown by code stage: Data type mismatch in criteria expression.

I just want to know what could be the possible causes? can anyone please help. ?

Thanks

[Mukeshh_k]

Hi Sourabh Sharma,

It seems there are issues with your Data column format - Kindly check the format of your column in the excel sheet- Try making all the columns format as Text and retry it, it should be able to perform the update.

Regards

Mukesh