upload excel file save data to in sql different tables

Question

i have excel file like below
sno name fname dob empid epsal
1 raju ravi 15/05/1990 123 40000

upload Import Excel Sheet data into SQL Server using ASP . in different tables like..
table_a
sno name fname dob
1 raju ravi 15/05/1990
table_b
empid empsal
123 40000

plz write csharp code

Jacke Elis · Answer

JAYRAM try this: var excel = ExcelFile .Load( Sample.xlsx ); var sheet = excel.Worksheets[0]; var table_a = sheet.CreateDataTable( new CreateDataTableOptions ( A1  sheet.Rows.Count 3) { ColumnHeaders = true }); var table_b = sheet.CreateDataTable( new CreateDataTableOptions ( D1  sheet.Rows.Count 3) { ColumnHeaders = true }); using ( var conn = new SqlConnection ( your-connection )) { conn.Open(); using ( var bulkCopy = new SqlBulkCopy (conn)) { bulkCopy.DestinationTableName = table_a.TableName; bulkCopy.WriteToServer(table_a); bulkCopy.DestinationTableName = table_b.TableName; bulkCopy.WriteToServer(table_b); } } I used this C# component for excel files  as you can see it can easily export a part of your excel file to a DataTable object . Note that you can read both XLSX and XLS excel files in same manner with C# . After the conversion it is just a matter of how you prefer to write to a server. I used SqlBulkCopy as a straightforward solution but this will depend on what you're actually trying to do.

shi lianghong · Answer

A sample here http://msdn.microsoft.com/en-us/library/ms140052.aspx