I want to insert data from DatagridView1 to my Access (mdb) database on my Visual Basic Project. I have a large amount of data (approximately 12,000 lines) on Datagridview1. So I use a For loop to insert. 
Here is my code:
   for i = 0 to Datagridview1.Rows.Count - 1
      a = Datagridview1.Rows(i).Cells(0).Value
      b = Datagridview1.Rows(i).Cells(1).Value
      c = Datagridview1.Rows(i).Cells(2).Value
      d = Datagridview1.Rows(i).Cells(3).Value
      If studentsTableAdapter.CountStudent(a, b)=0 Then
         studentsTableAdapter.Insert(a, b, "-", "New", c, 1)
      End If
      infoTxt.Text = "Saving " & i & "/" & Total
      infoTxt.Refresh()
   Next i
It works as expected, but sometimes it stops to insert and an error occurs like:
System.Data.OleDb.OleDbException (0x80004005): Unrecognized database format
This error occurs on different steps of for loops. (some times it does not occur).
Is there any reliable way to insert large amount of data from Datagridview1 to mdb database?
User contributions licensed under CC BY-SA 3.0