Meghana M

Meghana M

  • 1.5k
  • 175
  • 19k

how to import data from CSV to sql server

Mar 10 2023 12:56 PM

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

 


Answers (1)