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

Question

Hi Friends How to insert a Excel File into VS (Asp.net 4.0) and then create a new table in SQL MS with the Excel File data ?

Garry Gibson · Answer

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 ());

Hemant Kumar · Answer

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