How can I get a Make Table query to run via Macro?

[boulderman]

The closest Argument I can find is OpenQuery which merely opens it.

How do I get a Make Table Query to run, either using Macro, VBA or ADO.

Cheers

 

[cookiegary01]

You need to save a Query as a Make Table Query.
Then when you RUN the query (Or use Macro "Open Query"), the query will not open, but the table will be created.