Database :Adventerworks
Table 1: HumanResources.Department
Table 2: HumanResources.Employee
Here conditon is that the sheet of excel should be same as below:
Template:
Here data is coming from Table 1
colA colB colC colD colE colF
DepartmentID1
Namesusan
GroupNamehr
ModifiedDate17/01/2010
In the below data is coming from Table 2
EmployeeIDNationalIDNumber ContactID LoginIDManagerID
1122020202157de12
223212121123ds43
Something like: