title: Insert Data into SQL Table from an Excel Sheet
body: <p>if I have the following table in SQL,</p>
  
  <pre><code>Item  Desc   Type   Location    Quantity    Unit_Price
  
  A     AAA     X        1           0          20.00
  B     BBB     Y        2           0          10.00
  B     CCC     X        2           0          50.00
  C     DDD     Z        1           0         150.00
  C     EEE     Y        3           0          70.00
  D     FFF     Z        3           0          65.00
  </code></pre>
  
  <p>And the following Excel Sheet</p>
  
  <pre><code>Item    Location   Quantity
  A          1           1
  B          1           2
  B          2           3
  C          1          40
  C          3         500
  D          3          10
  </code></pre>
  
  <p>How do I insert these quantities in to the SQL table reading from my Excel table ?</p>