title: Syntax Error: Comma in Query Expression of SQL Statement?
body: <p>Alright folks, I am 100% Batshit insane at this point. Can someone possibly help me here? I'm clueless after trying EVERYTHING and searching for others with this experience. I'm at a loss here. I've tried brackets around all the table/field names. I've tried taking the tablename off the Select fields, I've tried moving the parenthesis backwards and forwards but to no avail.</p>
  
  <p>The error I get is: "Syntax Error (comma) in query expression. '( [F1], [F2], [F3], [F4], [F5], [F6], [F7], [F8] )'.</p>
  
  <pre><code>    CurrentDb.Execute "INSERT INTO [tblSalesJournal] ( [Store], [Business Unit], [Country], [State], [Store Type], [Net Sales], [Fee], [Total] ) " &amp; _
      "SELECT ( [F1], [F2], [F3], [F4], [F5], [F6], [F7], [F8] ) " &amp; _
      "FROM [tblImport]"
  </code></pre>
  
  <p>Any help is GREATLY appreciated</p>