title: Field doesn't exist in destination table Access 2016
body: <p>I'm trying to import a csv file into my Access database with an Excel macro with the following command:</p>
  
  <pre><code>AppAcc.DoCmd.TransferText cImportDelim, "", "US_Before", "R:\ProBusiness\Before_Data.csv", True  
  </code></pre>
  
  <p>When it hits this line, I get a run time error 2391 Field "PK__ doesn't exist in the destination table US_Before.</p>
  
  <p>I have checked all of the headings in the Access table as well as the csv file and they all appear to match to me.  None of the headings have spaces in the name.  I have also compile access, compacted and repaired the database, rebooted my machine, and made sure there are no extra columns or rows in the data file. We are on Office 365 and Windows 10.</p>
  
  <p>This same line works for a Canadian file (different field names) without any issues.  </p>
  
  <p>I'm not sure what the issue is.  Any help would be GREATLY appreciated.  Thanks for your time.......</p>