No Tables Appear in Add Tables Dialog Box
Article ID: 164383
Article Last Modified on 1/19/2007
APPLIES TO
- Microsoft Excel 2002 Standard Edition
- Microsoft Excel 2000 Standard Edition
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0 Standard Edition
- Microsoft Query 2000
This article was previously published under Q164383
SYMPTOMS
When you attempt to query a Microsoft Access database using Microsoft
Query or the Get External Data command in Microsoft Excel, the Add Tables
or Choose Columns dialog box may appear blank.
You may also receive the following error message:
This data source contains no visible tables.
CAUSE
This problem occurs if you use a Microsoft Access database and a
folder with the same name in the same directory. For example, the Add
Tables or Choose Columns dialog boxes appear blank if a folder named
"Northwind" and a Microsoft Access database named "Northwind.mdb" exist in
the same directory, as in the following example:
C:\Program Files\Microsoft Office\Office\Samples\Northwind
C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb
RESOLUTION
To resolve this problem, do not use a folder and a Microsoft Access
database with the same name in the same directory.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Additional query words: empty MSQuery
Keywords: kbbug kbualink97 KB164383