title: Import fixed width text to SQL
body: <p>We have records in this format: </p>
  
  <pre><code>99 0882300 25 YATES ANTHONY V MAY 01 12 04 123456 12345678
  </code></pre>
  
  <p>The width is fixed and we need to import it into SQL. We tried bulk import, but it didn't work because it's not ',' or '\t' separated. It's separated by individual spaces, of various lengths, in the text file, which is where our dilemma is located.</p>
  
  <p>Any suggestions on how to handle this? Thanks!</p>