можно составить sql запрос типа:


и выполнить его любым способом

2 Serge Gavrilov
Скопируются ли при этом свойства полей, типа Caption?

Трудно сказать вот что написано в хелпе

SELECT field1 [, field2 [, ...]] INTO newtable [IN externaldatabase]
FROM source

The SELECT...INTO statement has these parts:

Part Description
field1, field2 Name of the fields to be copied into the new table.
newtable 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 Path to an external database. For a description of the path, see the IN clause.
source Name of the existing table from which records are selected. This can be single or multiple tables or a query.


Remarks

Use make-table queries to archive records, make backup copies of your tables, or make copies to export to another database or 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

You may want to define a primary key for the new table. When you create the table, the fields in the new table inherit the data type and field size of each field in the query's underlying tables, but no other field or table properties are transferred .(выделено мной)


To add data to an existing table, use the INSERT INTO statement instead to create an append query.