ODBC Driver Errors If Database Path Contains Special

Last reviewed: August 25, 1997
Article ID: Q127099
1.00 WINDOWS xlquery

The information in this article applies to:

  • Microsoft Query for Windows, version 1.0
  • Microsoft Query for Windows, version 2.0
  • Microsoft Query for Windows, version 8.0

SYMPTOMS

In Microsoft Query, when you add fields from a table to the data pane, you may receive one of the following error messages:

   Syntax Error in FROM Clause

   -or-

   <file path> isn't a valid path.

   -or-

   <filename.table name> isn't a valid name.

CAUSE

This behavior occurs when the path to the table that you add to the query contains a special character, such as a dollar sign ($).

RESOLUTION

To prevent these error messages, save the database file to a new directory so that the path and/or filename do not contain any of the special characters listed below.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Query for Windows 95, version 2.0.

MORE INFORMATION

You may receive the error message "Syntax Error in FROM Clause" if the path contains any one of the following special characters:

$ Dollar Sign ~ Tilde ! Exclamation Point % Percent Sign

&      Ampersand
- Hyphen } Right Brace ( Left Parenthesis ) Right Parenthesis ` Grave Accent (or Left Apostrophe) @ At Sign . Period

If the path contains a left brace ({), you may receive the error message "<file path> isn't a valid path."

If the path contains an apostrophe ('), you may receive the error message "<filename.table name> isn't a valid name."

In Windows 95, a directory having a long name such as "C:\My Documents" will be seen as "c:\MyDocu~1" by Microsoft Query 1.0.


KBCategory: kbtool
KBSubcategory: xlquery

Additional reference words: 1.00 MSQuery Btrieve dBASE FoxPro Paradox Text
Excel workbook
Keywords : xlquery kbtool
Version : 1.00
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: August 25, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.