copy record between tables

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.
 
B

Bill Edwards

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
Parsing a table 1
Copy record into same table 1
MS Access Copy record to another table based on a form input 1
MS Access Copy record to another table based on a form input 2
Copying data between duplicate records 2
Access Automatically Send a notification email once a record is added 0
copy table with records from one DB to other DB 2

Top