By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,073 Members | 1,253 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,073 IT Pros & Developers. It's quick & easy.

Linking excel to ms access query that is using linked tables

P: 12
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
Nov 17 '11 #1

✓ answered by 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.

Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,709
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.
Nov 17 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.