If you're looking for the Access syntax for a make table query it is:
SELECT Table1.[field1], Table1.[field2], Table1.[field3] INTO my_table
FROM Table1;
or
SELECT Table1.* INTO my_table
FROM Table1;
This of course differs from the actual sql syntax for making a table which is:
create table my_table as
select * from Table1;
-Tracy