COPY TABLE1 FROM C:\DB1.MDB TO C:\DB2.MDB

i have 2 db same structre and i want to copy the data of table1 from db1 to db2
but i dont want to include the first field(key field and dont care about it)  

i have done this in vb.net

    Private Sub UpdateData(ByVal SelSql As String)

        Dim sourceSQL As String = SelSql
        Dim targetSQL As String = SelSql
        Dim targetDA As New OleDbDataAdapter(targetSQL, CON1)
        Dim cb As New OleDbCommandBuilder(targetDA)
        Dim targetCommand As OleDbCommand = cb.GetInsertCommand
        Dim cmdText As String = targetCommand.CommandText

        If CON2.State = Data.ConnectionState.Closed Then CON2.Open()
        If targetCommand.Connection.State = Data.ConnectionState.Closed Then targetCommand.Connection.Open()

        cmdText = cmdText.Replace("( ", "( [")
        cmdText = cmdText.Replace(" , ", "] , [")
        cmdText = cmdText.Replace(" )", "] )")
        cmdText = cmdText.Replace("[?]", "?")

        targetCommand.CommandText = cmdText
        Dim sourceCommand As New OleDbCommand(sourceSQL, CON2)
        Dim sourceReader As OleDbDataReader
        sourceReader = sourceCommand.ExecuteReader()

        Me.Text = 0
        While sourceReader.Read()
            For i As Integer = 1 To sourceReader.FieldCount - 1
                targetCommand.Parameters(i - 1).Value = sourceReader(i)
            Next
            targetCommand.ExecuteNonQuery()
            Me.Text = Me.Text + 1
        End While

        sourceReader.Close()
        CON2.Close()
        targetCommand.Connection.Close()
    End Sub

https://www.experts-exchange.com/questions/21975556/copy-database-data-from-one-database-to-onother-same-structure.html 

this works but is there any better way this takes to much time

Dimitris