title: Parsing txt file in Access VBA
body: <p>I have never used Access VBA, but I need to create a module that parses a txt file and then immediately imports it into a table.</p>
  
  <p>A dumbed-down of the txt is this:</p>
  
  <pre><code>15686541
  
  468469
  
  48978965
  
  456287
  
  48666545
  
  45684651
  
  456788
  </code></pre>
  
  <p>I need to parse it in order to </p>
  
  <ol>
  <li>Remove all the line/rows that are not six characters long</li>
  <li>Add commas after the third and fifth characters</li>
  </ol>
  
  <p>The final result being something like:</p>
  
  <pre><code>468,46,9
  
  456,28,7
  
  456,78,8
  </code></pre>
  
  <p>All this must be done in an Access VBA module so that the importing process becomes seamless. </p>
  
  <p>Thanks a lot!</p>
  
  <p>Sorry to bother</p>