Insert to Excel file from ASP.NET
The following ASP.NET program insert data into an excel file columns using OLEDB connection . In order to run this program you have to have an existing excel file with two column named as ID and NAME in the specified location of the connection string.
Data Source=ExcelFile.xls : you have to specify the Excel file location.
For inserting data into an Excel file using OLEDB , we have to create an insert statement like in SQL operations.
Dim sql As String = "Insert into [Sheet1$] (id,name) values('4','d')"
string sql = "Insert into [Sheet1$] (id,name) values('3','c')";
Click the following links to see full source code