It's not, as Mary Ann Richardson shows us. SQL Server lets you use one command to quickly create a new table containing a subset of records from a larger table. For example, suppose in Access you ...

Start SQL Server Query Tool Click the Start button and launch the Microsoft SQL Server Management Studio. Click the Server Name menu and choose your server from the drop-down list. Click Connect.

Typically, you would request an INSERT when no match was found in the target table. The nice thing about the MERGE statement is that duplicates do not create Primary Key violations.