title: Access Import CSV file
body: <p>I'm trying to import a CSV file into Access. However the way the CSV file is formatted, it creates three lines for the same transaction. Is it possible to tell Access that every three lines belong to the same transaction when creating or appending the table? VBA is fine, if that's the only way possible.</p>
  
  <p>Currently during the import for one transaction, Access creates 8 fields for the first line, 29 fields for the second line, and 8 more for the third line. I would either prefer having the 48 fields for the one transaction or telling access I only need certain fields.  For example, I need only field 2 of the first line, field 11 of the second line and field3 of the third line for each transaction. </p>
  
  <p>Thanks in advance for your help. </p>