Article ID: 171899 - View products that this article applies to.
This article was previously published under Q171899
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:
Syntax error in FROM clause.
This data source contains no visible tables.
This problem occurs if the following conditions are true:
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.mdbNOTE: 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".
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
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.
Article ID: 171899 - Last Review: January 20, 2007 - Revision: 2.4
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Contact us for more help