Do you know that this code has worked before? I could be wrong, but I think that whenever you are embedding a string into the SQL code, you still need the apostrophes around it. For example:
"'" & Nz(rstImportThese![Sname], " ") & "'," & _
"'" & Nz(rstImportThese![Fname], " ") & "'," &...