Use Chr(34) to Embed Quotation Marks Inside a String

sSQL = “SELECT * FROM tbl WHERE myCol=” & Chr(34) & sValue & Chr(34)

‘Chr() functions returns the character associated with an ANSI character code.