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

First, create a table with the required keys, constraints, domain checking, references, etc. Then use an INSERT INTO..SELECT construct to populate it. Do not be tempted by SELECT..INTO..FROM constructs. The resulting table will have no keys, therefore wil

stackoverflow.com