copying a record to another table

  • Thread starter Thread starter Nathan
  • Start date Start date
N

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
 
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
Click to expand...

Execute an Append query using the querydef object's Execute method.
 
Nathan said:
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?
Click to expand...


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.
 
Back
Top