Can you create a table from the output of a query?

B

BobC

Using MA 2007 ...
I would like to create a new table from the output of a query.
Can this be done ... if so how?
Thanks
Bob
 
D

Douglas J. Steele

You can create an INSERT INTO query based on the query you've created.

You'd create it the same as any other Make Table query, except you'd base it
on your query, not a table.
 
C

Christopher Robin

Yes it can. In the Query Designer, just select the Make Table button on the
ribbon and provide a table name.
 
J

Jeff Boyce

Douglas has provided a "how to"...

Now, I'm curious as to "why", as in "why do you believe you need 'to create
a new table from the output of a query'"?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
B

BobC

That was certainly quick!
Thanks much!


Christopher said:
Yes it can. In the Query Designer, just select the Make Table button on the
ribbon and provide a table name.
Click to expand...
 
B

BobC

Fair enough ...
I want to extract data from a very large SharePoint file to use in an
Access application for another project.
 
J

Jeff Boyce

Bob

So, no worries about "synchronization" between the data in Sharepoint and
the data in the new app?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

Creating a Search using a combo box and then creating a report. 4
Best way to use the Document Shape 0
Removing a repeated words 0
Create a chart from a table in word thats dynamic 0
Black Lines appearing over table borders 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Append Crosstab Query to Existing Table 0
Language of the templates 0

Top