How does OLEDB deals with mixed data types when working with .csv files?
<p>I have been writing an implementation for reading a .csv data file into C# datatable and do some basic string manipulations.</p>

<p>It all works well until it meets the cell with mixed data type. for example, "40C". Then it doesn't even read, it just skips it.</p>

<p>I've been researching online on possible ways to solve this issue but it looks like there is no other way to do it.</p>

<p>I've read it somewhere that I would need to use SQL or Acess to make it work but then wouldn't I run into the same problems when dealing with mixed data types?</p>

<p>Does any one know of a better way to solve this  problem? I would really love to stay with .csv extension though.</p>

<p>P.S. I am not posting my code due to the fact that it works but not for mixed data types but if you would insist, I can post the code.</p>

<p>Thank you in advance! </p>
