When I try to insert data from an MS-Access query into MS-Excel by using
Data > Import External Data > Import, and then selecting the relevant
MS-Access database., I can only see a limited number of the queries from
this database. I cannot see any logic in how these queries have been
selected, so apparently by random!

How can I possibly get access to all the queries in the database?

Mogens