turning query result into a table

[Guest]

I have written a SQL code that generates a large table. I can look at the
table, but how do i save it as a Table? That is, how can i save the results
of my query so that when i go to the tables section of my Access Project I
will see the results in Table form?

 

[Rick Brandt]

I have written a SQL code that generates a large table. I can look at
the table, but how do i save it as a Table? That is, how can i save
the results of my query so that when i go to the tables section of my
Access Project I will see the results in Table form?

What's wrong with looking at the query? That is what they are for.

 

[Guest]

i don't have the same export options. do you know how to save the results as
a table?

 

[Rick Brandt]

i don't have the same export options. do you know how to save the
results as a table?

Please clarify. Queries can be exported.

You would have to change the query to a make-table query or feed it into a
make-table query. But believe me, you don't need to do this.

 

[Guest]

well then can you explain to me how i can export a table that i made with a
query that consists of around 1 million records to a csv file that can be
imported into Stata?

 

[Rick Brandt]

well then can you explain to me how i can export a table that i made
with a query that consists of around 1 million records to a csv file
that can be imported into Stata?

Save the query, Select it in the db window, and then go to File - Save
As/Export.