ODBC Driver Errors If Database Path Contains SpecialLast reviewed: August 25, 1997Article ID: Q127099 |
1.00
WINDOWS
xlquery
The information in this article applies to:
SYMPTOMSIn 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. CAUSEThis behavior occurs when the path to the table that you add to the query contains a special character, such as a dollar sign ($).
RESOLUTIONTo 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.
STATUSMicrosoft 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 INFORMATIONYou 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
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |