how to import data from CSV to sql server

Question

CSV file having multiple columns how to split between respective multiple tables

Eg: Sample1.csv file having :Id,Department,Name,Address,Qualification -Read from these csv file column to write 2 different tables and column names varies like Id in Sample1 file but in table1 it is EmpId

Table 1 : EmpId,EmpDepartment

Table2 :Name,Address