troubleshooting Question

Inserting data from Gridview/Datatable into access database

Avatar of sterankin
sterankin asked on
6 Comments1 Solution9848 ViewsLast Modified:
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  

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros