Notice your first error message. It appears that the syntax was fine, rather the problem was what you were trying to store in the database.
Your error message.
Data type mismatch in criteria expression.
My guess would be that you are trying to populate a numeric field in your database with a char.