title: Old school schema.ini question
body: <p>Anyone know how to specify a custom record delimiter in a schema.ini file? I need to import some data for an old system, and the source file uses pipes (|) as field delimieters and tilda's (~) as row delimiters. I've managed to get the field delimiters configured. Row delimiters anyone?</p>
  
  <p>The current schema.ini file...</p>
  
  <pre><code>
  [sourcefile.txt]
  ColNameHeader=false
  Format=Delimited(|)
  CharacterSet=ANSI
  Col1=F1 text
  Col2=F2 text
  Col3=F3 text
  Col4=F4 text
  Col5=F5 text
  ...
  </code></pre>
  
  <p>Oh, and yes, it has to be done this way. I can't work around it by importing it through some other means...</p>