What you want to do is insert the data in the database with the ' replaced with '' . This escapes the apostrophe and won't mess up the query.
I love the String object's Format method. It's an unusual application where I'm not using it to build messages. (Long ago and far away, I used to use it to assemble SQL statements.) Typical code looks ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback