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

Last Reply one year ago By AnandM

Posted one year ago

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