Data from one table to another

[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

 

[Alex White MCDBA MCSE]

If the field layout is similar between the two tables an "insert into"
append query is what you need.

 

[tina]

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

 

[Guest]

Thank you very much. That helped a lot.

If the field layout is similar between the two tables an "insert into"
append query is what you need.

--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

 

[Guest]

I really appreciate the help. It worked great.

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