No Tables Appear in Add Tables Dialog Box (164383)
The information in this article applies to:
- Microsoft Excel 2002
- Microsoft Excel 2000 with MultiLanguage Pack
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
- Microsoft Query
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.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
| Modification Type: | Minor | Last Reviewed: | 8/17/2005 |
|---|
| Keywords: | kbbug kbualink97 KB164383 |
|---|
|