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
Contact us for more help
Connect with Answer Desk for expert help.