Copying records

From: George Kvasha (gkhokie_at_hotmail.com)
Date: 10/30/04 

Date: Sat, 30 Oct 2004 11:24:08 -0400

In D6 using an Access database, how can I copy an entire record from one
table to another without having to assign fieldvalues? The two tables have
identical structures except for the autonumber index field.