Creates a make-table query.
SELECT field1[, field2[, ...]] INTO newtable [IN externaldatabase]
FROM source
The SELECT...INTO statement has these parts:
Part | Description |
---|---|
field1, field2 | The name of the fields to be copied into the new table. |
newtable | The name of the table to be created. It must conform to standard naming conventions. If newtable is the same as the name of an existing table, a trappable error occurs. |
externaldatabase | The path to an external database. For a description of the path, see the IN clause. |
source | The name of the existing table from which records are selected. This can be single or multiple tables or a query. |
You can use make-table queries to archive records, make backup copies of your tables, or make copies to export to another database or to use as a basis for reports that display data for a particular time period. For example, you could produce a Monthly Sales by Region report by running the same make-table query each month.
Notes
SELECT...INTO Statement Example