You are currently offline, waiting for your internet to reconnect

"Syntax error in FROM clause" when getting external data

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

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 itdoes 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).
When the path to the file contains a period, the path is qualifiedincorrectly by Microsoft Query. As a result, the Structured Query Language(SQL) statement for the data you are retrieving is incorrect, and youreceive the error message in the "Symptoms" section.
msquery get external data create new query XL2000 XL XL2003

Article ID: 214377 - Last Review: 03/22/2007 17:06:31 - Revision: 5.2

  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
  • kberrmsg kbpending kbprb KB214377