SELECT *
INTO  [IN ]
FROM old_tablename

SELECT column_name(s)
INTO  [IN ]
FROM old_tablename

SELECT *
INTO Persons_Backup
FROM Persons

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

SELECT LastName,FirstName
INTO Persons_Backup
FROM Persons

SELECT LastName,Firstname
INTO Persons_Backup
FROM Persons
WHERE City=

SELECT Persons.LastName,Orders.OrderNo
INTO 
FROM Persons
 JOIN Orders
ON Persons.P_Id=Orders.P_Id