Import Access Query to Excel

[Jonathan Kim]

I am trying to import MS Access Query to Excel.
I tried with "Data --> Import External Data --> Import Data" but I
found two issues.

First, "Select Table" lists only 5 of 15 query tables I made.
Second, data range only displays column headings, no record.

Both Access and Excel files are on local drive.
My computer is on domain network and I heard there is a security issue
with Import External Data within domain environment. However, I used
to do this on my previous employment within domain environment.

I appreciate any help!
Thank you!


Jonathan Kim