If you wish to query Access from Excel, then maybe this solution will work for you. Since you have not shared your files, I am only guessing at solutions, but from what you describe this may be a direction you wish to go.

http://datapigtechnologies.com/blog/...ry-from-excel/