access and excel macro

[Klartigue]

I have an access database with a table of accounts. I have a query named "cashcomp" that pulls all the accounts from the table that fit this category. I know I can export the results of this query to excel but is there any way to write a macro in excel that exports this query from access and into excel. I want the export process to be automatic in an excel macro so I don't have to do this manually before running the macro. in excel.

My access file is located here: G:\Fixed Income\Accounts

Thanks for the help