I receive a "syntax error in INSERT INTO statement" error when executing the following statement, and would be grateful of your assistance with the correction. I believe that the required text delimiters are in place.
SQLStr1 = "INSERT INTO " & tbl & " IN '" & txt_Output_Db & _
"' SELECT FROM '" & txt_db1 & "' WHERE POSTCODE = '" & pc & "'"
Thanks in advance