Re: Copy between identical tables

From: Gérard Leclercq (gerard.leclercq_at_pas-de-mail.fr)
Date: 02/23/05 

Date: Wed, 23 Feb 2005 17:14:04 GMT

The SELECT INTO Statement
The SELECT INTO statement is most often used to create backup copies of
tables or for archiving records.

Syntax
SELECT column_name(s) INTO newtable [IN externaldatabase]
FROM source

--------------------------------------------------------------------------------

Make a Backup Copy
The following example makes a backup copy of the "Persons" table:

SELECT * INTO Persons_backup
FROM Persons

The IN clause can be used to copy tables into another database:

SELECT Persons.* INTO Persons IN 'Backup.mdb'
FROM Persons

If you only want to copy a few fields, you can do so by listing them after
the SELECT statement:

SELECT LastName,FirstName INTO Persons_backup
FROM Persons

You can also add a WHERE clause. The following example creates a
"Persons_backup" table with two columns (FirstName and LastName) by
extracting the persons who lives in "Sandnes" from the "Persons" table:

SELECT LastName,Firstname INTO Persons_backup
FROM Persons
WHERE City='Sandnes'

Selecting data from more than one table is also possible. The following
example creates a new table "Empl_Ord_backup" that contains data from the
two tables Employees and Orders:

SELECT Employees.Name,Orders.Product
INTO Empl_Ord_backup
FROM Employees
INNER JOIN Orders
ON Employees.Employee_ID=Orders.Employee_ID