Article ID: 214377 - View products that this article applies to.
This article was previously published under Q214377
For a Microsoft Excel 97 and earlier version of this article, see 171899
When you use Microsoft Query 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 problem occurs if you attempt to retrieve data from a Microsoft Access or Microsoft Excel database, and the path to the database contains a period (.), for example:
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).
When the path to the file 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.
Contact us for more help
Connect with Answer Desk for expert help.