how to convert result of an select sql query into a new table in ms access

Question

how to convert result of an select sql query into a new table in msaccess ?

Answer 1

You can use sub queries

SELECT a,b,c INTO NewTable 
FROM (SELECT a,b,c
FROM TheTable
WHERE a Is Null)

Answer 2

Like so:

SELECT    *
INTO      NewTable
FROM      OldTable