title: Split two strings into one row in SQL (Access)
body: <p>I have a table with strings:</p>
  
  <pre><code>Field1
  150120154030
  201012
  </code></pre>
  
  <p>And I want to insert the data from the two string rows into a table like this:</p>
  
  <pre><code>F1         F2  F3  F4    F5   F6
  15012015   40  30 20   10   12
  </code></pre>
  
  <p>Any help to write the query for this?</p>