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

  • Thread starter Thread starter BobC
  • Start date Start date
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
 
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.
 
Yes it can. In the Query Designer, just select the Make Table button on the
ribbon and provide a table name.
 
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
 
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...
 
Fair enough ...
I want to extract data from a very large SharePoint file to use in an
Access application for another project.
 
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
 
Back
Top