How do i exeucte a query thats in an access database through VB6?

I have an access database with several querys in and a VB6 program the manipulates access. I want to be be able to add an 'update' button that copys the contects from one access table then pastes it in an empty access table. This table maybe updated so it needs to overwrite what may already be in it.
I have included the main code so far but its the middle bit i havn't got!

Private Sub btnUpdate_Click()
    Dim rA As Integer
    Dim db As New ADODB.Connection
    Dim sSQL As String
    
   
   db.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = \\Server\test Database\testDatabase.mdb"
   db.Open
  
      MsgBox "Completed!!"
   
      db.Close
      Set db = Nothing
End Sub

Select allOpen in new window