Updating Excel Cell with Non-Numeric Data in C#

Posted by kbo206 on Stack Overflow See other posts from Stack Overflow or by kbo206
Published on 2010-03-24T05:28:25Z Indexed on 2010/03/24 5:33 UTC
Read the original article Hit count: 315

Filed under:
|
|
|

I have a query that is ExcelQuery = "Update [Sheet1$] set CITIZEN_ID = #" + value + " where CITIZEN_ID = " + value; As you can see, I'm essentially just appending a "#" onto the CITIZEN_ID field. value is a int/numeric value. So if I had "256" in the CITIZEN_ID column it would be converted to "#256"

When I execute this I get an OleDbException Syntax error in date in query expression so I surrounded part of the query in single quotes like this, ExcelQuery = "Update [Sheet1$] set CITIZEN_ID = '#" + value + "' where CITIZEN_ID = " + value; With that I get yet another OleDbException this time with, Data type mismatch in criteria expression.

I'm guessing for some reason the CITIZEN_ID fields don't want to take anything besides a plain number. Is there any way I can remedy this to get that pound symbol in?

Thanks!

© Stack Overflow or respective owner

Related posts about excel

Related posts about c#