Through a macro, first you would open the query using OpenQuery action in the macro and then the next action would be 'Output TO'. In the output to action, you can pick if you want a flat text file or excel or any format you wish. Alternatively, you can do this using make table query.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.