title: Load csv into oleDB and force all inferred datatypes to string
body: <p>Im trying to load a csv file into a datatable using oledb.</p>
  
  <p>This is no problem but unfortunately one of the fields which looks numeric has a string value in about 3% of the fields and so is not being populated.</p>
  
  <p>because im converting the csv into xml i really don't care about inferring datatypes and simply need the data in a string as i can cast it later in a Linq2XMl phase.</p>
  
  <p>I am hoping to be able to do this in the connection string.</p>
  
  <p>I don't want to just copy the table, set it up with new columns with the datatype I want and then write the data into it because that would involve loading the csv file twice.</p>
  
  <p>any ideas?</p>
  
  <p>my current connection string is</p>
  
  <p>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + thefile.DirectoryName + ";Extended Properties='text;HDR=Yes;FMT=Delimited'";</p>