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.

I'm fairly certain what you want to be using is DTS. It the wizard interface lives under Import/Export data. IMO, It's one of the best tools that has ever been designed for the computer.

How to Create a Table From Query Results in Microsoft SQL. If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results.

I create a simple view in my database which performs some aggregation ... LINQ in .NET returning duplicate rows from a working SQL view [SOLVED ... it simply took the first column in the table.

Effectively maintaining an Access database requires the regular removal of duplicate records. The Find Duplicates Query wizard handles this chore quickly and easily. When maintaining an Access ...