into operator in sql
-- INTO copies specified columns into a new table
SELECT *
INTO newtable [IN externaldb]
FROM oldtable
WHERE condition;
SELECT column1, column2, column3
INTO newtable [IN externaldb]
FROM oldtable
WHERE condition;
Eg: SELECT * INTO CustomersBackup
FROM Customers;
SELECT * INTO CustomersBackup IN 'Backup.mdb'
FROM Customers;
SELECT CustomerName, ContactName INTO CustomersBackup2017
FROM Customers;