Excel Prefixcharacter in C# with OLEDB causing "Data type mismatch in criteria expression" error on UPDATE

Question

When updating an Excel file using OLEDB from C# I get the error "Data type mismatch in criteria expression" if the original file has a hidden PrefixCharacter (apostrophe in my case). If I remove the apostrophe from the cells in the original file, my application works as expected and the data is updated without any errors. Any suggestions on how to remedy this problem other than manually removing the PrefixCharacter before processing the file?

Answer 1

Hi,

I am encountering the same problem.. Did u find any solution to get rid of the apostrophe? Would appreciate any pointers to solve the problem.

muruge.