How to import excel sheet in SQL server using query.

Oct 26 2016 1:53 AM

1. Like in excel have 3 sheets (emp, manager, dept) and these sheets have their own columns and data.

2. So the manner to insert data from excel to sql's table is like sheetName same as sql TableName & their data.

3.and I do not run query three times means when we run query/script they insert these 3 table ...or many more.