title: VBA/ADO: reading mixed data types from a .csv datasource
body: <p>I'm having a problem reading in mixed datatypes from a .csv datasource: Strings are returned as Null's when I have a column with mixed String/Numeric values. I have set IMEX=1 and changed the Registry entry TypeGuessRows from 8 to 0 (but even if I have mixed datatypes within the first 8 rows, strings are still coming through as Null). Also ImportMixedTypes=Text in the registry. </p>
  
  <p>What am I missing?? Any ideas much appreciated.</p>
  
  <p>Here's my connection string:</p>
  
  <pre><code>ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" _
      &amp; "Data Source=" &amp; Folder &amp; ";" _
      &amp; "Extended Properties='text;HDR=YES;FMT=CSVDelimited;IMEX=1';" _
      &amp; "Persist Security Info=False;"
  </code></pre>