Create an Access Table from an Access Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We are dealing with Microsoft Access 2003. Is there any easy way to turn a
query into a table???

Thanks in advance for your help.

wnfisba
 
Hi

Open the query in design view and select the View option. Select Make Table
choose a name and save. Right click the query and select open. You will be
asked if you want to make a table. Click Yes.
 
Change it to a Make Table query:

Open the query in design view, go to Query>Make-Table query..., enter the
name of the table you want to create, press OK. Now run your query.

Ed Metcalfe.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table layout 1
Printing Access Table Definition 4
SQL Server thread issue and long running query 3
Importing an Excel worksheet into Access 3
Partial Key within Access 5
Access Pipeline to SQL Server and inefficiencies 7
Running macros one line at a time 1
Pass-Through Query SQL Security 3

Back
Top