C# code to Import Excel data in to SQL server 2008
<p>My question which is the  best approach to import the data from Excel to SQL server 2008. It has lots of check like duplicates check etc.,</p>

<p>I would say we have  </p>

<p>1.Import Export wizard<br>
2.SSIS package<br>
3.Create a .NET Console App  with inline query<br>
4.Create a .NET console app with stored proc because it has lots of checking conditions.  </p>

<p>Which is the best approach?</p>

<p>thanks in advance</p>
