Copying data from one form to another

[Eddie]

I need to copy all of my data fields from one table to
another, possibly two. Anyone know what the code would
look like to do this?

Your assistance is appreciated.

-Edm

 

[John Vinson]

I need to copy all of my data fields from one table to
another, possibly two. Anyone know what the code would
look like to do this?

Your assistance is appreciated.

-Edm

An Append query (or a MakeTable query for a new table) is the simplest
way to do this.

HOWEVER - storing the same data redundantly in multiple tables is
generally a Very Bad Idea. Could you explain why you need to do this?
What is your intended use of the second/third tables?

 

[Eddie]

Hey,

The first table is actually a temporary storage table used
to filter out bad or redundant data. Once the fields are
all verified as accurate the record is then copied over
into our actual inventory (and the temporary entry is
deleted), where it sits until it is again shipped (the
inventory is cleared), and copied over into our outgoing
archive.


Thanks,

Edm

 

[John Vinson]

Hey,

The first table is actually a temporary storage table used
to filter out bad or redundant data. Once the fields are
all verified as accurate the record is then copied over
into our actual inventory (and the temporary entry is
deleted), where it sits until it is again shipped (the
inventory is cleared), and copied over into our outgoing
archive.

Ok... that makes plenty of sense.

Simply run an Append query appending from the temp table into the real
table.

If you'll be doing this routinely, be sure to Compact your database
regularly; the space occupied by the deleted records will not be
reused, and you can get the database bloating pretty rapidly.