hi,
your post is confusing????
"I am working on dropping some Access queries in Excel using the External
Data
function (Data -- Import External Data -- Import Data)."
hey. no problem... Microsoft query(MSQ)... been doing that for 10 years.

"I have no problem getting some queries and tables to show up in Access
databases. "
uh..wait a minute. which way are we going here??????? your can link excel
named ranges to access and access will view them as "tables" but your
previous sentence said access to excel??????

"However no linked tables or queries that use linked tables show up."
??? show up where ???? access or excel ??????

"Is there any way to get the external data working with linked
tables? "
you can link excel files(named ranges) to access and access will view them
as tables but you must use MSQ (or ADO..not recomended by this person as
excel to access and vice versa) to download access tables (or queries) to
excel.

someone may come alone and correct me but as stated....been doing this for
some time.

post back with clarifications. please. very confusing. even contradictory.

regards
FSt1

..
"Grant I" wrote:

I am working on dropping some Access queries in Excel using the External Data
function (Data -- Import External Data -- Import Data). I have no problem
getting some queries and tables to show up in Access databases. However no
linked tables or queries that use linked tables show up. Is this a known
"feature"? Is there any way to get the external data working with linked
tables?

Thanks!
Grant