Code:
Dim dt As New DataTable  

02         Dim ds As New DataSet  

03    

04         con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source= C:\Test.accdb" 

05    

06         con.Open()  

07         MsgBox("here")  

08         ds.Tables.Add(dt)  

09    

10         Dim da As New OleDbDataAdapter  

11    

12         da = New OleDbDataAdapter("SELECT * FROM Table1", con)  

13    

14         da.Fill(dt)  

15    

16    

17         Dim newRow As DataRow = dt.NewRow  

18    

19         newRow.Item(1) = Item1  

20         newRow.Item(2) = Item2  

21         newRow.Item(3) = Item3  

22         newRow.Item(4) = Item4  

23         newRow.Item(5) = Item5  

24         newRow.Item(6) = Item6  

25         newRow.Item(7) = Item7  

26         newRow.Item(8) = Item8  

27         newRow.Item(9) = Item9  

28         newRow.Item(10) = Item10  

29         newRow.Item(11) = Item11  

30         newRow.Item(12) = Item12  

31         newRow.Item(13) = Item13  

32         newRow.Item(14) = Item14  

33         newRow.Item(15) = Item15  

34         newRow.Item(16) = Item16  

35         newRow.Item(17) = Item17  

36         newRow.Item(18) = Item18  

37         newRow.Item(19) = Item19  

38         newRow.Item(20) = Item20  

39         newRow.Item(21) = Item21  

40         newRow.Item(22) = Item22  

41         newRow.Item(23) = Item23  

42         newRow.Item(24) = hms  

43         newRow.Item(25) = ymd  

44         newRow.Item(26) = SingleElapsedTime.Text  

45    

46    

47         dt.Rows.Add(newRow)  

48         Dim cb As New OleDbCommandBuilder(da)  

49         da.Update(dt)  

50         MsgBox("Record successfully saved", vbInformation)  

51         con.Close()
I am getting a error at da.Update(dt) and I am unsure why as I ran it with about 10 items and it ran perfect very unsure why now. Here is the error. OleDbException was unhandled : Syntax error in INSERT INTO statement. Thanks for any advice or help.