Upload Monthly data

You didn't mention the target database system. SQL Server, Oracle, MySQL?

 

If it is SQL Server, you can use Import / Export wizard in SQL Server Management Studio.

public ActionResult UploadExcel(HttpPostedFileBase FileUpload)

{

if (FileUpload != null)

{

if (FileUpload.ContentType == "application/octet-stream" || FileUpload.ContentType == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")

{

string filename = FileUpload.FileName;

string targetpath = Server.MapPath("~/Doc/");

FileUpload.SaveAs(targetpath + filename);

string pathToExcelFile = targetpath + filename;

var connectionString = "";

if (filename.EndsWith(".xls"))

{

connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0;", pathToExcelFile);

}

else if (filename.EndsWith(".xlsx"))

{

connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";", pathToExcelFile);

}

var adapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString);

var ds = new DataSet();

adapter.Fill(ds, "ExcelTable");

DataTable dtable = ds.Tables["ExcelTable"];

string sheetName = "Sheet1";

var excelFile = new ExcelQueryFactory(pathToExcelFile);

var variableName= from a in excelFile.Worksheet(sheetName) select a;

foreach (var a in variableName)

{

try

{

a.propertyname;

a.propertyname2;

}//try end

} //forloop

}//if

}//if

}//method 

Hellow,

 

1. Create following table in database

 

2. Read one by one rows from excel file.

 

3. Insert in below database tables.

 

 

Employees
ID	Name
1	Yesubabu
2	Dharmraj

 

 

Addendances
ID	EmployeeID	Date	Status
1	2	01/01/2018	1
2	2	02/01/2018	1
3	2	03/01/2018	1
4	2	04/01/2018	1
5	2	05/01/2018	0
6	1	01/01/2018	1
7	1	02/01/2018	0
8	1	03/01/2018	1
9	1	04/01/2018	1
10	1	05/01/2018	1

 

Try This :