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??