title: MS Access Import UTF-8 file with BOM causes issue if the next char is double quote?
body: <p>I found a strange issue, I'm wondering if anyone knows either why this happens or if it is a known bug (yes I Googled).</p>
  
  <p>I have a database where I have to import CSV files using Access. I'm making some changes to the project to allow UNICODE characters to be into the database. There is some preprocessing involved in VBA by reading and writing using ADODB.Stream. </p>
  
  <p>This ADODB.Stream is the only method of processing UNICODE files that I found to be of a useful level. However, I'm writing UTF-8 files with it and obviously, as it should, it writes a BOM (Byte Order Mark) at the start of the file: <code>ï»¿</code>. </p>
  
  <p>So far so good Microsoft, way to support standards! Now when this file is saved I want to import it using an ImportExportSpecification. I specifically specify Microsoft's Codepage 65001 which is what the rest of the world calls utf-8. Then try to import and no surprise it works.. <em>Until</em> your file starts with a double quote, then Access complains that the record 2 (2??) could not be parsed.</p>
  
  <p>The unfortunate thing is that I cannot control the source of these files and I'm not involved in the actual imports, it's automated.. So now I either have to remove the BOM, which I don't really want to do.. because I need to read and write the entire file from to disk or in memory and these files are insanely huge.. Or remove the double quote, which is actually necessary for the headers of a file (that I can't control either).</p>
  
  <p><strong>TL;DR:</strong> It appears that if your files starts with <code>ï»¿"</code> you break Access's ImportExport module. Is it a bug, a "feature" or why the .. does it happen?</p>
  
  <p>Ok, so I will remove the BOM, so Christmas doesn't have to start without me. <strong>But</strong> it's <strong>not</strong> a solution, it's a band aid. I would very much like to know how to fix this, it's itching me.. :) </p>
  
  <p>Merry Christmas!</p>