Import a CSV file into Access using VBA
<p>I need to use VBA to import a large CSV excel file into an Access table. The delimiter is "" (double quotes) except for some reason the first value is followed by " (only one quote) instead of two like every other value. The first row contains the column headers and are delimited the same way. At the bottom I have attached an example.</p>

<p>The CSV files are generated automatically by an accounting system daily so I cannot change the format. They are also quite large (150,000+ lines, many columns). I'm fairly new to VBA, so as much detail as is possible would be much appreciated.</p>

<p>Thanks in advance!</p>

<p><a href="http://i.stack.imgur.com/FkUi5.png" rel="nofollow">Example of format</a></p>