title: excel ace.oledb vba connection to csv returning only first column
body: <p>In VBA Excel (Office 365) trhough using a connection string like <code>&quot;Provider=Microsoft.ACE.OLEDB.12.0;data source=...&quot;</code> and using the command string  <code>SELECT * FROM [text;HDR=Yes;FMT=Delimited;Delimiter=';';database=KKS].[kks.csv];</code> the results are:
  <a href="https://i.stack.imgur.com/dPZCD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dPZCD.png" alt="enter image description here" /></a> when the CSV source looks like this:</p>
  <pre><code>rng;key;component;
  &quot;0&quot;;&quot;A&quot;;&quot;Grid and distribution systems&quot;;
  &quot;0&quot;;&quot;B&quot;;&quot;Power transmission and auxiliary power supply&quot;;
  </code></pre>
  <p>The <code>schema.ini</code> is:</p>
  <pre><code>[kks.csv]
  ColNameHeader=True
  Format=CSVDelimited
  Decimalsymbol=(,)
  Delimiter=(;)
  </code></pre>
  <p>I have tried any combination for the connection string and for schema.ini (also removing it completely) and the results are the same at best. Any suggestion? Thank you!</p>