title: Export Excel data into SQL Server table in asp.net c#
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/5141521/how-to-insert-data-from-excel-sheet-to-sql-server-2005">How to insert data from Excel sheet to SQL Server 2005</a>  </p>
  </blockquote>
  
  
  
  <p>I have an Excel sheet like below </p>
  
  <p>Country name         Port        01/01/05        02/01/05</p>
  
  <p>geria            Arw     25000       10000</p>
  
  <p>That data should insert into a table like this</p>
  
  <pre><code>CountryName     Port        date            cal
  1    geria          Arw     01/01/05        25000
  2    geria          Arw     02/01/05        10000
  </code></pre>
  
  <p>How can I insert this type of data into datatable?</p>