Microsoft Access - Create New Tables From External Queries (Access 97/2000/2002)
When you create a new Access database, you'll sometimes want to work with the results of an external query but you won't have any other need for the query's underlying tables. Fortunately, you don't have to import the unnecessary data. There are a slew of ways to accomplish the task, but the easiest to do may be the easiest to overlook--you can import the query as a new table. To do so, select File | Get External Data | Import from the menu bar. Select the appropriate database and click Import, then select the queries you want to import on the import Objects dialog box-s Queries property sheet. Next, click the Options button and select the As Tables option button in the Import queries panel. Finally, click OK. Access processes the queries and saves the results as a table with the same name as the original query.