copying a record to another table

[Nathan]

I have 2 tables that have the same structure within the
same db. What is the best way to copy an entire record
from one to the other using code?

Thanks

Nathan

 

[John Vinson]

I have 2 tables that have the same structure within the
same db. What is the best way to copy an entire record
from one to the other using code?

Thanks

Nathan

Execute an Append query using the querydef object's Execute method.

 

[Marshall Barton]

I have 2 tables that have the same structure within the
same db. What is the best way to copy an entire record
from one to the other using code?

First you have to specify how you're going to identify the
record to be copied. Then you can run an Append (SELECT
INTO) query to to select and copy the record.