Save querry to a table

[Gunilla]

I am using Access 2003 and I would like to create a table from a querry. I usually go via Excel but sometimes there are too many records. The information is downloaded via ODBC and I don't need all the information only a fraction. Is it possible to do this?
Thanks for your help

 

[jzwp22]

Yes, it is possible, but once you append the data to another table you effectively lose the connection to the ODBC source. In other words, if data in the source changes, it would not be reflected in the data in your table.

If that is OK with what you are doing, then you need to create the new table that will hold the data. Then change the type of your current query to an append query, select the new table name, correlate the fields of the query to the corresponding ones of the table and then run the query.

You mentioned that there are too many records in your query. Can't you use some criteria to filter the results down to what you need?

 

[jdraw]

I'm not really sure what you are asking, but as a start you may want to look up Make Table query.


You can convert a SELECT query to a Make Table query.

Hope I've guessed correctly.

 

[jzwp22]

As jdraw suggests, the Make table query will make the table and append the records in one execution.

I just separated it into two steps, but you would get equivalent outcomes.

 

[Gunilla]

Thank you guys, I just forgot about the make a table querry. Sometimes it's good to have somone to point out the obvious.
Bye for now from a rainy Sacramento, CA