title: Comma separating text in field in MS Access 2016 Query
body: <p>I have a csv file (updated 3 times a week. I have no control over its format, so cannot normalise it) that I have created an OBDC-link to a MS Access 2016 database.(I have chosen MS Access to refresh my skills with it, otherwise would complete in SQL). I have tried various permutations in setting up the OBDC link for the linked table however none give the optimum structure for the other fields. </p>
  
  <p>The CSV file looks like this:  </p>
  
  <pre><code>Fecha de Sorteo,Numero de sorteo,Numero de Juego,Nombre,Valores Principales,Comodines,DRAWNAME,Ganadores de Premio Mayor,Premio Mayor Garantizado
  "8/25/2002 12:00:00 AM","1714","1","main","31,34,26,1,2,28","16","Loto","0",
  </code></pre>
  
  <p>I am trying to create a query to comma separate Field 3 into its 6 component parts. I have seen many examples that separate either 2 or 3 components (but never more than that) using InStr and the Mid functions such as seen <a href="http://www.databasedev.co.uk/splitting_fields.html" rel="nofollow">here</a>.</p>
  
  <p>Do I have to create multiple expressions to separate this field into its components or is their an alternate solution?</p>