MS query missing table error

C

ChrisP

I am trying to link Excel to an Access file using MS Query (Excel: 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?
 
D

Dirk Goldgar

ChrisP said:
I am trying to link Excel to an Access file using MS Query (Excel:
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?
Click to expand...

Is the database by any chance stored in a folder with the same filename?
If so, this may be the problem:

http://support.microsoft.com/default.aspx?id=164383
No Tables Appear in Add Tables Dialog Box
 
C

ChrisP

Dirk Goldgar said:
Is the database by any chance stored in a folder with the same filename?
If so, this may be the problem:

http://support.microsoft.com/default.aspx?id=164383
No Tables Appear in Add Tables Dialog Box

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...

Dirk,
Thanks for your reply. I tried the link - which describes the problem
exactly. I moved the database to another directory just in case, but it is
still the same. I can link to other databases in the same directory, so it
seems to be something wrong with my database. All the tables are visible in
Access.

Regards

Chris P
 
D

Dirk Goldgar

ChrisP said:
Dirk,
Thanks for your reply. I tried the link - which describes the problem
exactly. I moved the database to another directory just in case, but
it is still the same. I can link to other databases in the same
directory, so it seems to be something wrong with my database. All
the tables are visible in Access.
Click to expand...

How odd. I can't check this out myself, but while I was searching for
answers on this question, I ran across a number of posts from users who
fixed a similar problem by checking a box in the Excel query dialog to
"include system tables" -- or something like that; I don't remember
exactly. You might try that and see if it works for you. Failing that,
you may want to take your question to the Excel newsgroups.
 
Top