| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel link to access query not working
In Excel 2007 I have used the "get external data" function to link to an
access database query. However it comes out blank in Excel (the header row is there but no data). Table, pivot chart and pivot table are all blank. The query is OK in Access. If I instead link to a table in the same Access database this works (i.e. I see the data). What's going on? The query isnt very complicated, it just joins three tables together. It has an expression and a couple of criteria (Like "yes*") but that's it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link to MS-Access Query | Excel Discussion (Misc queries) | |||
| Import query from access to excel, link to template, email on | Links and Linking in Excel | |||
| Removing Link to Access Query | Excel Discussion (Misc queries) | |||
| Link Access query to refresh an EXCEL file | New Users to Excel | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Linear Mode
