title: access vba array by looping through recordset
body: <p>I have a loop which I want to create an array then use the array to insert into another table.</p>
  
  <pre>
  Band     Country 
  AIR       FR 
  Bon Jovi  US 
  Oasis     UK 
  Blur      UK 
  Green Day US 
  Metalica  US 
  </pre>
  
  <p>I want to loop through this recordset, so I want to create arrays, for example, arrayFR = "AIR"; arrayUK = "Blur vbCrLf Oasis" and arrayUS = "Bon Jovi vbCrLf Green Day vbCrLf Metalica".</p>
  
  <p>At the same time, based on this recordset, I have created a temp table with columns FR, UK &amp; US. I hope to use the arrays created, then insert into the temp table like the view below.</p>
  
  <pre>
  FR        UK        US 
  AIR       Blur      Bon Jovi 
            Oasis     Green Day 
                      Metalica 
  
  </pre>
  
  <p>I don't know how to start with as I have searched a lot of arrays related pages but doesn't help, please help me gurus! Thanks in advance!</p>