copy record between tables

  • Thread starter Thread starter Alberto
  • Start date Start date
A

Alberto

Hi,
I have two tables with same structure. I need to copy a record from one
to other using vba codes. I'd like avoid to copy field to field.

Thank you.
 
Without knowing anything about your table structures, something similar to
the following:

Dim strSQL As String
strSQL = "INSERT INTO tblCopy SELECT tblOriginal.* " _
& "FROM tblOriginal WHERE tblOriginal.KeyValue = 4"
CurrentProject.Connection.Execute strSQL
 
Back
Top