MS Access Bulk Insert exits app
- by Brij
In the web service, I have to bulk insert data in MS Access database.
First, There was single complex Insert-Select query,There was no error but app exited after inserting some records.
I have divided the query to make it simple and using linq to remove complexity of query. now I am inserting records using for loop. there are approx 10000 records.…