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? |
#2
|
|||
|
|||
Hi Chris, The tables are probably hidden. If Access is set up to show hidden tables, you may not notice this, although the icon is slightly dimmer. Open the database, right click on the table name, select Properties, and there is a checkbox at the bottom that says Hidden. If this is checked, the deselect it and this should show up the tables on Excel. Al the best, Roly -- roly ------------------------------------------------------------------------ roly's Profile: http://www.excelforum.com/member.php...o&userid=24631 View this thread: http://www.excelforum.com/showthread...hreadid=401959 |
#3
|
|||
|
|||
"roly" wrote: Hi Chris, The tables are probably hidden. If Access is set up to show hidden tables, you may not notice this, although the icon is slightly dimmer. Open the database, right click on the table name, select Properties, and there is a checkbox at the bottom that says Hidden. If this is checked, the deselect it and this should show up the tables on Excel. Al the best, Roly -- roly ------------------------------------------------------------------------ roly's Profile: http://www.excelforum.com/member.php...o&userid=24631 View this thread: http://www.excelforum.com/showthread...hreadid=401959 Roly, Thanks for your post. No, the tables are not hidden. In fact, I tried hiding a table and then unhiding it, but now I can't find it at all! Regards Chris P |
#4
|
|||
|
|||
Hi Chris, Have you tried compacting the database? This seems to cure loads of stuff. If so can you upload it and I will have a look? All the best, Roly -- roly ------------------------------------------------------------------------ roly's Profile: http://www.excelforum.com/member.php...o&userid=24631 View this thread: http://www.excelforum.com/showthread...hreadid=401959 |
Reply |
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) |