code for saving the query output to a table

[Guest]

Hi!

When I run a query, the data gets displayed in Datasheet view (automatically).

Can someone please show me how to write the code that would save the data in
a table?

Thanks!

 

[Guest]

depends on whether you're adding a new table or adding new records to an
existing one.
but on the query menu, simply change the query type to an append query (and
then you need to specify the table, and which field goes where) or a
make-table query (specify table name etc).

both are very straight forward.

 

[John Nurick]

When I run a query, the data gets displayed in Datasheet view
(automatically).

Can someone please show me how to write the code that would save the data
in
a table?

Usually it's neither necessarily nor desirable to save the results of a
query into another table, because that gives you two copies of the data -
and consequent problems keeping them consistent. Instead, just use queries
to get whatever view of the data you need.