SELECT...INTO Statement Example

This example selects all records in the Employees table and copies them into a new table named Emp Backup.

SELECT Employees.* INTO [Emp Backup] FROM Employees;