>>INSERT INTO TABLE city (id,cityname) VALUES(1,"vald'or") >>>
insert into table city(id,cityname) values (1,'vald'or')shows only single quotes. He didn't specify any reason why the code didn't work, but I assumed he was getting a Syntax Error because of the mis-matched quotes.
lcSql = "insert into table city(id,cityname) values (1,'vald''or')"
would be appropriate. (I don't work with SQL Server but I think that is the way you put a quotation mark into a string).