select into table (temporary or not)

A

Alur

In SQL Server we can use
select into #temp_table_name(or: ##temp_table_name; table_name)
from ... .
Could you show the way to do the same in Access with access tables into
access tables which are not existing before ?
Is there any possibility to use temporary access tables in Access 2002 ?
 
O

Ofer

Create a make table query to create a new table based on existing records

SELECT MyTableName.* INTO NewTableName
FROM MyTableName;
 
Top