If the table doesn't exist then
SELECT Table1.[ID], Table1.[Field1], Table1.[Field2], Table1.[Field3] INTO Table2 FROM Table1;
If the table already exists then
INSERT INTO Table2
SELECT Table1.[ID], Table1.[Field1], Table1.[Field2], Table1.[Field3]
FROM Table1;
I switched to SQL View to do this. Sorry I don't know how to do it in Access' Design View