Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/171899

From BetaArchive Wiki

Article ID: 171899

Article Last Modified on 1/20/2007


  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft Access 97 Standard Edition

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:

Microsoft Query

Syntax error in FROM clause.

Access 97

This data source contains no visible tables.


This problem occurs if the following conditions are true:

  • You attempt to retrieve data from a Microsoft Access database.

  • The path to the database or the database name itself contains a period (.), for example:


  • You attempt to retrieve data from a Microsoft Excel workbook.

  • The table range in the workbook is called "Database".


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".


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.

Additional query words: XL97 XL7 7.0 msquery get external data create new query XL

Keywords: kbbug kberrmsg KB171899