External data link to Access - no linked tables?

G

Grant I

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
 
F

FSt1

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

..
 
F

FSt1

it's 1:12 in atlanta. gonna crach. i will chech back tomorrow.
good night.
regards
FSt1
Jesus saves.
 
G

Grant I

I'm actually going the other way - trying to display Access tables/queries in
Excel. The menu steps I listed were from Excel - you can have an Access
table or query be an external data source that populates the Excel sheet, but
it seems like Excel can't read linked tables from the access database. Sorry
for the confusion & thanks for your help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top