How to insert to multiple tables using single excel file??

Rajneesh Chaubey

Please refer to this article:-

http://www.c-sharpcorner.com/UploadFile/0c1bb2/inserting-excel-file-records-into-sql-server-database-using/

My question is, can we upload data to multiple tables using single excel file. Like in above case you are inserting to single table. I want something like id, name and address goes to one table whereas designation and id goes to another table. Can we do that?? How??

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suraj Kumar8y ago
Accepted answer
Hello,

Can you try after repeating these lines
SqlBulkCopy objbulk1 = new SqlBulkCopy(con);
//assigning Destination table name
objbulk1.DestinationTableName = "Employee2"; //The name of another table
//Mapping Table column
objbulk1.ColumnMappings.Add("Name", "Name");
objbulk1.ColumnMappings.Add("City", "City");
objbulk1.ColumnMappings.Add("Address", "Address");
objbulk1.ColumnMappings.Add("Designation", "Designation");
//inserting Datatable Records to DataBase
con.Open();
objbulk.WriteToServer(Exceldt);
con.Close();
Thanks
Rajneesh Chaubey8y ago
Worked!! Thank you very much.