Read and Import Excel Sheet data into Database using C# and VB.Net in ASP.Net

Last Reply on Jan 30, 2017 03:23 AM By AnandM

Posted on Jan 29, 2017 11:16 PM

I have an excel sheet it contains 9columns 

Fr ex: name Address Phnenum Area City State Country fathername Sex

It has 9 columns .


But I want to get only 5 Columns

Fr Examp: Name Num FatherName sex Addr


Here Column names is different in my Project

1.In excel it has [phnenum]

but in my database it has [Num]

2.In excel it has[Adderess]

but in my database it has[addr]


So in this case we get the values and save it to the database