I am attempting to append a string literal to a query string and execute the query. My issue is that I can not discover how to properly encapsulate the string literal with quotes so when the string is executed it fails. This is my syntax - what is the correct way to encapsulate the string with quotes?
Code:Dim inputText As String, strSQL As String inputText = "Hi" strSQL = "Select red, blue, green, " & inputText & "from house" Debug.Print strSQL Select red, blue, green, hi from house