title: How to import csv file to Access with VBA code?
body: <p>I have a csv file, that I need to import to Access using VBA.</p>
  
  <p>I'm using the following code : </p>
  
  <pre><code>Call DoCmd.TransferText(acImportDelim, , TableName, SourceFile, HasFieldNames)
  </code></pre>
  
  <p>Where TableName, SourceFile and HasFieldNames are variables that store information about the file.</p>
  
  <p>The import works but I have only one column imported in the table.</p>
  
  <p>Does anyone have an idea please ?</p>
  
  <p>The file is a csv with the separator ";" and has multiple columns.</p>
  
  <p>Thank you.</p>