Create table from query

  • Thread starter Thread starter gclute
  • Start date Start date
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?
 
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.
 
Back
Top