Create table from query

[gclute]

Using a macro how do you copy a query file and save it as a table file?
I know you can do it with the export drop down command picking the option to
save it as a table but how do you do it with a Macro?

 

[Steve Schapel]

Gclute,

Make the query into a Make-Table Query (select Make-Table from the Query
menu in design view). Then use an OpenQuery action in your macro to run it.