How to import data from .dat file into SQL Server in MVC

See more:

ASP.NET

MVC

jQuery

WebAPI

My requirement is I want to browse the file with extension .DAT(test.DAT) file in my MVC4 application, where the user can select the file. There is a Same columns in both my database table as well as in the .DAT(test.DAT) file. Before importing the data in the table of the database the Columns present in the .DAT(test.DAT) file should be compared with the Columns in the database.
1)Selecting The .DAT(test.DAT)file with data Columns and Rows same as Table designed in .DAT(test.DAT) file rows and Columns.
2)All rows and Columns like in .DAT(test.DAT) file Table also designed with same fromat in SQL Server Database in a same format.

3)When I upload this .DAT file file i need to Save the .DAT file data into Data base tables same as in .DAT file Using MVC4

This is data of .DAT file
test.dat file data
1 528 Q25E test2 10-02-13 10.5789
2 587 Q26F Adta 11-05-14 14.25789

Should Be save in database like this
Table designed like this
Id EmpID Code Name Date Amount
1 528 Q25E test2 10-02-13 10.5789
2 587 Q26F Adta 11-05-14 14.25789