i can't see where is the Invalid character with the SQL statement below. i can't see where i miss any character or i added extra characters.

mySQL = "UPDATE table SET col1 = '"_& rA & "', col2 = " & rB & ", col3 = " & rC & ", col4 = " & rD & ", col5 = " & rE ", col6 = " & rF & " WHERE primaryKey = '" & primary "'"

possible double quotes at end, but i missed it, sorry.

mySQL = "UPDATE table SET col1 = '"_& rA & "', col2 = " & rB & ", col3 = " & rC & ", col4 = " & rD & ", col5 = " & rE & ", col6 = " & rF & " WHERE primaryKey = '" & primary "'"