insert string into db table using sql

statustx=”i’ll do it”
strSQL = “INSERT INTO otherstatus (sendby,sendto,message) ”
strSQL=strSQL & “SELECT ”
strSQL=strSQL & “‘” & empl & “‘ as text1,”
strSQL=strSQL & “‘” & recieverid & “‘ as text2,”
strSQL=strSQL & “‘” & statustx & “‘ as text3 ”

the problem with ‘ in string statustx,it closes the singlr quote in sql statement..how should i do it?