Data from one table to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to transfer records from one table to another in the same database and
then delete the records in the original table. I am using the first table as
a temporary table and it needs to be cleared out after they information is
posted to the permanent table.

Any help is greatly appreciated.

Thanks
 
If the field layout is similar between the two tables an "insert into"
append query is what you need.
 
you can use an Append query to copy the records from the temporary table to
the permanent table. then use a Delete query to delete the records from the
temporary table. look up "append query" and "delete query" in Access Help
for details.

hth
 
I really appreciate the help. It worked great.

tina said:
you can use an Append query to copy the records from the temporary table to
the permanent table. then use a Delete query to delete the records from the
temporary table. look up "append query" and "delete query" in Access Help
for details.

hth
Click to expand...
 
Back
Top