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?

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" 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

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