title: Reading delimited text file?
body: <p>I am trying to read from a delimited text file, but everything is returned in in one row and one column.</p>
  
  <p>My connections string is </p>
  
  <pre><code>OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
      Path.GetDirectoryName(@textBox1txtPath.Text) + ";" + 
      "Extended Properties=\"text;HDR=YES;IMEX=1;Format=Delimited(|)\"");
  </code></pre>
  
  <p>And my text file reads:</p>
  
  <pre><code>ItemNumber|ProductStatus|UPC
  0000012|closed|2525
  </code></pre>
  
  <p>Please assist</p>