How to read values from multiple text files and then save it

Question

Hi, I have many text files which has details (say Employee details). one text file for each employee.

Now I need to read each file, get the details (like Emp_Name, Emp_ID, Address etc.,) and then save it  into SQL database directly.

Can someone please help me on this. 

 

In the text file, each details are separated by ";"  (semicolon)

Ex:

File1:

EmpID:   101

EmpName:   Nagaraja

Address:   Bangalore 

 

File2:

EmpID: 102

EmpName: Deepak

Address: Bangalore