Create table from query

G

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?
 
S

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.
 
Top