Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
External data link to Access - no linked tables?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
External data link to Access - no linked tables?
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
External data link to Access - no linked tables?
it's 1:12 in atlanta. gonna crach. i will chech back tomorrow.
good night. regards FSt1 Jesus saves. "FSt1" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
External data link to Access - no linked tables?
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! "FSt1" wrote: it's 1:12 in atlanta. gonna crach. i will chech back tomorrow. good night. regards FSt1 Jesus saves. "FSt1" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can Excel import access that has tables linked to exel? | Excel Discussion (Misc queries) | |||
updating external data sheet causes loss of data on linked pages | Excel Worksheet Functions | |||
Excel to Access linked tables | Excel Discussion (Misc queries) | |||
Use checkboxes with linked external data? | Excel Discussion (Misc queries) | |||
External link only works for numbers -- for text values, #N/A is displayed unless linked file is open | Links and Linking in Excel |