Article ID: 110588 - View products that this article applies to.
This article was previously published under Q110588
A physical table in a database has records (rows) and fields (columns). A single record contains a single row of field values.
To copy a record in one table to another table, you need to copy all the fields in the source record to the corresponding fields in the destination record. You can do this by using the Value property of the Fields collection, or by using an SQL statement.
How to Copy a Record Using SQLYou can use the SQL Insert Into statement to copy specified records from one table into another:
You can also add a WHERE clause at the end to add any selected records:
How to Use SQL Statements in Visual BasicHere's an example showing how to use the SQL statements in Visual Basic code:
How to Copy a Record Using the Fields Collection and Value PropertyThe following loop copies all the fields in the current record in table 1 to the corresponding fields in the current record in table 2:
The above loop assumes that the fields in table 2 are identical to those in table 1.
Article ID: 110588 - Last Review: October 29, 2003 - Revision: 2.0
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.