"Syntax Error in FROM Clause" When Getting External Data (171899)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Access 97
This article was previously published under Q171899 SYMPTOMS
When you use Microsoft Query or Access 97 to return external data to a
worksheet in Microsoft Excel or when you view returned data in Microsoft
Query, you may receive the following error message:
Microsoft Query
Syntax error in FROM clause.
Access 97
This data source contains no visible tables.
CAUSE
This problem occurs if the following conditions are true:
- You attempt to retrieve data from a Microsoft Access database.
-and-
- The path to the database or the database name itself contains a period
(.), for example:
-or-
- You attempt to retrieve data from a Microsoft Excel workbook.
-and-
- The table range in the workbook is called "Database".
WORKAROUND
To work around this problem, change the path to the database so that it
does not contain any periods, for example:
C:\MyTest\Northwind.mdb
C:\My Test\Northwind.mdb
NOTE: You may use a period before the file name extension (.mdb in this
case).
Or, rename the table range in the workbook to a name other than
"Database".
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. MORE INFORMATION
When the file name path contains a period, the path is qualified
incorrectly by Microsoft Query. As a result, the Structured Query Language
(SQL) statement for the data you are retrieving is incorrect, and you
receive the error message in the "Symptoms" section.
| Modification Type: | Minor | Last Reviewed: | 8/17/2005 |
|---|
| Keywords: | kbbug kberrmsg KB171899 |
|---|
|