title: Import Excel into SQL Server with ASP.NET MVC in a list so it will easy
body: <p>I have a table where I have fields </p>
  
  <pre><code>public class Exceldate
  {
      public virtual int Id { get; set; }
      public virtual string Name { get; set; }
  }
  </code></pre>
  
  <p>I have a SQL Server 2008 table <code>Exceldate</code>... and I have an Excel sheet in the sheep there is 2 field ID and Name... I just want to fetch that data by list... simple </p>
  
  <p>There are 10000 rows </p>
  
  <p>My question which is the best approach to import the data from Excel into SQL Server 2008? It has lots of check like duplicates check etc.,</p>