Meghana M

Meghana M

  • 1.6k
  • 175
  • 23.6k

Import CSV file to Database table

Mar 11 2023 12:10 PM

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

Eg: Sample1.csv file having :Id,Department,Name -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

Sample2.csv file having :Id,Name,Address,Qualification -Read from these csv file column to write 2 different tables and column names varies like Name in Sample2 file but in table2 it is EmpName

Table 1 : EmpId,EmpDepartment,EmpName

Table2 :EmpId,EmpName,EmpAddress,EmpQualification

 


Answers (4)