Upload excel file data into sqlserver database table

Question

Hi Everybody,

 

I want to upload excel file data into sqlserver database table using mvc with jquery.

 

Please use ado.net code for DAL. [ don't take entity frame work].

 

In My excel file

 ============

 ID  Name                              

 1   Krishna

  2  Ganesh 

 

 

Table :

=====

 ID Name    ID--NewID()

 

 

Regards,

=======

Sai.