Copy from one table to another

[gundie]

A newbie question... I'm re-coding a program I wrote in MS Access using VB .Net. I'm trying to copy the content from one table (partdata) into another (temp). Both tables have identical number of fields and field names (part_number & part_price).

In Access, I used a "docmd.runsql" to execute a SQL INSERT statement to copy the table. How can I do the same in VB .Net?

[tolisss]

      Dim cnNew As New OleDb.OleDbConnection(cntProvider & "Data Source=" & Application.StartupPath & "\db.mdb")
       cnNew.Open()
       Dim cmd As OleDbCommand

        cmd = New OleDbCommand("INSERT INTO TABLE1 ( FirstN, LastN, Address, Phone, Dimoi, Job )
SELECT TABLE2.FirstN, TABLE2.LastN, TABLE2.Address, TABLE2.Phone, TABLE2.Dimoi, TABLE2.Job
FROM TABLE2;
", cnNew)
        Try
            cmd.ExecuteNonQuery()
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try
        cnNew.Close()