FileTables, a new feature introduced in SQL Server 2012, is a unique table that reflects metadata of files in a specified folder.

Navigate to the directory you saved the create_tables.sql file in (in my case, /home/jack) and select the create_tables.sql file. Scroll down and click the Go button and the tables will import.

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.