Linking excel to ms access query that is using linked tables

[James Armstrong]

Hey guys I am trying to link from excel to an access query I created. The query I created in Access uses linked sql tables via odbc. When using excel's import external data tool I am able to log in and view all of my tables and queries, yet I am only able to pull data into excel that does not reference my linked tables. When trying to link to any of my linked tables or queries using linked tables I get a connection error. Is there a better way to attempt this? My main goal is to have an excel spreadsheet that users can view and refresh with up to date data.

Thanks for looking

[NeoPa]

I don't believe MS Query (the tool used by Excel to link to Access and create queries) is able to piggy-back off an Access database in the same way that Access can. IE. That you can connect to anything that Access connects to without a separately defined link.

This would mean your having to link via ODBC to the source tables instead I believe.