Insert a excel file into a sql server table along with some other columns

See more:

C#

ASP.NET2

I have an excel file with 4 columns and i have a sql server 2008 table with 6 colums, in that two columns are not there in the excel file.
while uploading the excel file (bulk) i have to read the two columns values from the user(drop down list) and upload them along with excel file. please help.

Ex:

Excel file columns(R.No, Name, Father Name, Gender)
Sqlserver columns(Branch, Year,R.No, Name, Father Name, Gender)

Enter Branch:
Enter Year:
Upload Excel File:__________(Browse for Excel File)

Upload Button