title: Excel Import Into Access
body: <p>I have 3 spreadsheets that I want to import into Access but I"m having a problem figuring it out. I'm not even sure it can be done the way I want to do it.</p>
  
  <p>One Spreadsheet looks like this:</p>
  
  <pre><code>StoreNum, SKU_1, SKU_2, SKU_3, ..., SKU_1000  
  1, 0, 100, 25, ..., 1  
  2, 5, 250, 15, ..., 5  
  3, 78, 25, 12, ..., 15
  </code></pre>
  
  <p>How can I import this so I have StoreNum, SKU, Qty?</p>
  
  <p>The others are easy for me to understand</p>
  
  <pre><code>StoreNum, Address1, Address2, City, State, Zip  
  </code></pre>
  
  <p>and</p>
  
  <pre><code>Sku, Description, Notes, Size
  </code></pre>