Copy record info to other table

[Marcel Fernee]

Hi,

I would like to copy data from one table to another
table. How do I program this? I can acces all the current
data, but I don't know how to acces and write to a table
that is not the current active one.

Thanks,
Marcel Fernee

 

[Dirk Goldgar]

Hi,

I would like to copy data from one table to another
table. How do I program this? I can acces all the current
data, but I don't know how to acces and write to a table
that is not the current active one.

Normally you'd write and run an append query that selects the specific
records and fields that you want from the first table and appends them
to the other table.