Moving data between tables

  • Thread starter Thread starter Maracay
  • Start date Start date
M

Maracay

Hi guys,

There is a way to transfer the data from table tblOne to tblTwo, tblOne has
35 columns and tblTwo has the same 35 columns plus some other columns, what I
want is to create a command button to transfer the matching columns from
tblone to tbltwo, the only way I know is moving field by field, I just want
to know if there is a faster way to do this.

Thanks
 
You can use an append query followed by a delete query.

Why can you not just use one table and have criteria in your queries to
distinguish between the data sets?
 
Back
Top