title: Quote within a .CSV data field
body: <p>Here is my current connection string:</p>
  
  <pre><code>string connString = String.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=""{0}"";Extended Properties=""text;HDR=NO;FMT=Delimited\""",Path.GetDirectoryName(csv_file_path));
  </code></pre>
  
  <p>This works fine except I have a few lines of code as follows:</p>
  
  <pre><code>"jon","smith","ohio"
  "tom","jones","indiana"
  "mary","baker "mills","florida
  </code></pre>
  
  <p>The last line has quotes within the field and the field is ending before "mills".  Does anyone have a connection string that can accommodate a quote within a data field?</p>
  
  <p>Thanks!</p>