title: MS Access VBA script to interface with Excel
body: <p>I am trying to write a VBA scriptin Microsoft Access that will interface with an Excel sheet, loop through rows and then cells in the row, and then pull info back into the Access table. </p>
  
  <p>Here is some sudo code-</p>
  
  <pre><code>For Each Row
      For Each Cell in the Row
          Read the Cell
          Create a new Record in the Access table with the info from the cell
      End For Each
  End For Each
  </code></pre>
  
  <p>You can see a simplified example of the end result in the pictures below. </p>
  
  <p>What we have-</p>
  
  <p><img src="https://i.stack.imgur.com/Ayg8D.png" alt="enter image description here"></p>
  
  <p>What is needed-</p>
  
  <p><img src="https://i.stack.imgur.com/Y6yT6.png" alt="enter image description here"></p>
  
  <p>I have coded before, but never in VBA; so any help would be appreciated! Thanks for your help!!!</p>