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?