Insert String with Single Quote(')

daimous · #1 (**permalink**) 10-07-08, 03:23

Hi guys! Is it posible to insert a value with single quote(') in ms excel? My current code is displayed below. But when I try to insert a string say, "This message contains single quote(')" an error will occur stating

Quote:

Missing semicolon (

at end of SQL statement.

Thanks in advance!

Code:

Quote:

OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=myDB.xls";Extended Properties=\"Excel 8.0;HDR=YES\"");
OleDbCommand command = new OleDbCommand();
command.Connection = conn;
command.CommandText = "INSERT INTO myTable values('This message contains single quote(')');
conn.Open();
command.ExecuteNonQuery();

gvee · #2 (**permalink**) 10-07-08, 03:32

You want to escape the single quote.
The way to do this is to double it up

Code:

Replace(input_string, "'", "''")

daimous · #3 (**permalink**) 10-07-08, 05:42

Thanks it work!!

Internet Services

Web Development

Digital Marketing

Consumer Tech