http://www.adopenstatic.com/faq/80040e14.asp

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: strSQL = "INSERT INTO table([text]) VALUES(' & strText & "');"
: 
: 
: if strText = "John's dog died.", then it may caused error.
: how to solve it?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~