title: Too few parameters. Expected 1 CSV Import
body: <p>I'm trying to import a CSV file to my Access database via VBA. And I'm getting this error: "Run-time error: '3061': Too few parameters. Expected 1."</p>
  
  <p>I already tried adding single quotes, like the other threads suggested regarding this problem, but it didn't help. </p>
  
  <pre><code>    strSQL = "INSERT INTO Import (" &amp; _
           "[Equipment]" &amp; _
           ",[Description]" &amp; _
           ",[User_status]" &amp; _
           ",[Functional_Location]" &amp; _
           ",[Functional_Location_Desc]" &amp; _
           ",[Cost_Center]" &amp; _
           ",[Main_WorkCtr]" &amp; _
           ",[Manufacturer]" &amp; _
           ",[Model_Number]" &amp; _
           ",[Serial_Number]" &amp; _
           ",[Plant_Section])" &amp; _
           " SELECT Equipment,Description,User_status" &amp; _
           ",Functional_Loc,Description3,Cost_Center,Main_WorkCtr" &amp; _
           ",Manufacturer,Model_number,ManufSerialNo,Plant_section" &amp; _
           " FROM [Text" &amp; _
                  ";FMT=Delimited" &amp; _
                  ";HDR=YES" &amp; _
                  ";IMEX=2" &amp; _
                  ";CharacterSet=1252" &amp; _
                  ";DATABASE=" &amp; strFolder &amp; "].[" &amp; strFilename &amp; "]"
  
  CurrentDb.Execute strSQL
  </code></pre>
  
  <p>My CSV file's first line: Equipment,Description,User_status,Functional_Loc,Description3,Cost_Center,Main_WorkCtr,Manufacturer,Model_number,ManufSerialNo,Plant_section</p>
  
  <p><a href="http://i.stack.imgur.com/8vlYB.png" rel="nofollow">My Import Table</a></p>
  
  <p>Thanks for your help.</p>
  
  <p>Mark</p>