| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
MS Query No visible tables
I am trying to link Excel to an Access file using MS Query (Data/Get External
Data/New database Query/MS Access DAtabase. When I select the file, I get the message "This data source contains no visible tables". But the Access file has 5 tables. I have tried other Access files, some of which work OK, and others not. What do I need to do to the Access file to make this work? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Web Query from multiple tables | Excel Discussion (Misc queries) | |||
| MS Query cannot find tables in Access database | Excel Discussion (Misc queries) | |||
| Two Excel tables in MS Query | Excel Discussion (Misc queries) | |||
| Pivot Tables referring to external data query | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Threaded Mode
