I try to import data from Access into Excel by using menu Data/Import External Data/Import Data. In the Select Data Source dialog box I then point to my Access database. This brings up a list of queries (views) and tables that I can select between. So far so good.

But the list of tables does not contain the database tables that are linked tables, i.e. linking to a second Access database. Likewise, the list of queries is missing a lot of queries, probably all queries that are drawing on linked tables at some point down in the hierarchy of subqueries. This goes for Excel 2003 and 2007 as well.

Is this correct? Should it be so? What can I do to give Excel access to all Access tables and queries?