Replace "new_table" with the name of the table to create, and replace "old_table" with the name of the table to select from. The INTO clause behaves the same as CREATE TABLE in other SQL environments.

If you've been searching for a way to use the table structure in an existing Microsoft Access database in another table, then check out this quick tip. It shows how to copy and customize the table ...