how can i transfer data in access? (OFFICE XP)

P

placetobe

can i transfer/move data from one table to another in access - at the touch
of a button?
 
A

Allen Browne

Execute two SQL statements:
- one to INSERT INTO the new table;
- the second to DELETE FROM the old table.

To be safe, use the dbFailOnError switch, so the DELETE does not occur
without the INSERT. Ideally, wrap both in a transaction so you get an
all-or-nothing result. For details of how to do that, see:
Archive: Move records to another table
at:
http://allenbrowne.com/ser-37.html
 
Top