i want to save dataset from table (bible) to another table (tt) in access 2003 database
this is the code i have

vb Code:
  1. Private Sub Option1ToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Option1ToolStripMenuItem.Click
  2.        
  3.         Dim sQuery As String = "SELECT Bible.BookNum, Bible.ChapterNum, Bible.VerseNum FROM BibleBookNames INNER JOIN Bible ON BibleBookNames.BookNum = Bible.BookNum WHERE (((BibleBookNames.Book)=""" & DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(0).Value.ToString & """) AND ((Bible.ChapterNum)= " & ComboBox2.Text & ") AND ((Bible.VerseNum)=" & DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(1).Value.ToString & "));"
  4.         Dim SQLQuery As New OleDbDataAdapter(sQuery, CON)
  5.         Dim dsResult As New DataSet
  6.         SQLQuery.Fill(dsResult, "tt")
  7.  
  8.         Dim sCollection As String = "Select * from tt;"
  9.         Dim daCollection As New OleDbDataAdapter(sCollection, CON)
  10.         Dim objCommandBuilder As New OleDbCommandBuilder(daCollection)
  11.         daCollection.Update(dsResult, "tt")
  12.  
  13.  
  14.     End Sub

but nothing happen or being saved to the other table which is tt