Currently - the user creates and excel spreadsheet on their desktop with some data, then uses the ASP.NET web app to upload the excel spreadsheet. The data is read in from the spreadsheet and put into a DataTable which is then bound to a gridview for the user to see and verify.
I then want to be able to insert the data from the datatable into an Access DB (the columns should match).
How do I do this? Is there a simple way to Insert the datatable or the rows from the datatable into the access database?
Access table: TestTable
Columns: Column1, Column2, Column3, Column4 etc