create MS Access table through Queryman

[Lesio]

Anybody knows the SQL syntax to create table in MS Access ? Cannot do it in Access directly bc. of version mismatch.

 

[tracy1234]

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