Help with SQL statement!

apostrophes and quotation marks

[jefferson]

i have a string variable(txtmessage)
txtmessage has both apostrophes and quotation marks

my insert statement looks like this:

strSQL = "INSERT INTO MYTABLE (MESSAGE) VALUES (" & TXTAMESSAGE & ")"

fails every time. i must be able to allow both quotes and apost... but how?

using access

[iamlost]

Try using square bracket delimiters:
[" & TXTAMESSAGE & "]

if that doesn't work search MS or online re: microsoft access delimiters or similar.

[wsp9]

Try replacing each apostrophe in the string variable with two consecutive apostrophes.

In vbscript I think the function is: txtmessage=replace(txtmessage,"'","''")