How do i move records from one table to another ?

F

filnigeria

I need to copy the whole of one table (which is a temporary one) to a main
table withiin the same database
i want to do this before i delete the temporary tables
i have the delete scripts
now all i need is how to move them from one tableto another before i delete
them

HELP

Jordan
 
A

Arvin Meyer

filnigeria said:
How do i use this expression
can you pls so me an example
Click to expand...

First change the name of Table 2 to the tablename you want to copy to, and
Table1 to the tablename you want to copy from. Then start a new query,
choose Design View, then close the Add Table dialog. Choose the SQL button
and paste the code into that window. Run the query ONE TIME ONLY. You do not
have to save it. Open the target table to make sure the records have
appended OK, then delete the temporary table.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
F

filnigeria

this wont work cos the record feild are not named the same thus access
complians that field F1 doesn't exist
 
Top