Insert a Excel File into VS (Asp.net 4.0)

If you are using a newer excel format (XLSX) then you could check out OpenXML SDK, for example here:
http://stackoverflow.com/questions/3321082/from-excel-to-datatable-in-c-sharp-with-open-xml
Also you can check out this .NET Excel component, it provides a direct API for importing an Excel file to a DataTable in C#, like the following:

ExcelFile file = ExcelFile.Load("Book1.xlsx");
ExcelWorksheet sheet = file.Worksheets["Sheet1"];
 
DataTable dataTable = sheet.CreateDataTable(new CreateDataTableOptions());

Hi there,
This link sounds useful. It will use OleDbConnection to connect to the Excel file then loads it in a DataTable and then sends it to the SqlServer.
 
Import Data from excel to SQL server using C# in ASP. NET[^]
 
You can find more posts associated with importing Excel to SQL using C# in CodeProject
 
I hope it helps,