Microsoft KB Archive/125414

= WD: Errors When Querying on Data with Straight Quote/Apostrophe =

Article ID: 125414

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Word 6.0 Standard Edition
 * Microsoft Word 6.0a
 * Microsoft Word 6.0c
 * Microsoft Word 95 Standard Edition
 * Microsoft Word 95a
 * Microsoft Word 97 Standard Edition
 * Microsoft Word 6.0 for Macintosh
 * Microsoft Word 6.01 for Macintosh
 * Microsoft Word 6.01 for Macintosh

-



This article was previously published under Q125414





SYMPTOMS
When you attempt to query a data source in which a data record contains an apostrophe, you may receive one of the following error messages.

Word Data Source or Microsoft Excel Spreadsheet Using DDE or Converter (Windows and Macintosh)
Word could not parse your query options into a valid SQL String.

Microsoft Access Data Source Using ODBC (Windows Only)
Open Database Connectivity Error - 10014 in query expression ".

(Details button)

- ODBC Error: [Microsoft][ODBC Access Driver]10014 in query

expression ".

Error. Sql State: 37000.

Return Code: SQL_ERROR

Microsoft Access data Source Using DDE (Windows Only)
Word could not re-establish a DDE connection to Microsoft Access to complete the current task.

FoxPro data source using ODBC (Windows)
Open Database Connectivity Error - Syntax Error.

(Details button)

- ODBC Error: [Microsoft][ODBC Single-Tier Driver]Syntax

Error.

Sql State: 37000.

Return Code: SQL_ERROR

- SELECT *FROM WHERE

((""='O'Neil'<<???>>>))



CAUSE
The Word for Windows SQL query engine does not recognize a "straight" quotation mark or a "straight" apostrophe (as opposed to smart quotes, or curly quotation marks) as a valid SQL or query string. The above errors do not occur when using MS Query.



Method 1
Use smart quotes. To do this, follow these steps:

 If you have not created your Word data source, do the following:  Turn on Smart Quotes. On the Tools menu, click AutoCorrect, then click the "Change 'Straight Quotes' to 'Smart Quotes'" option. Type in the data using smart quotes. Copy the data to the Clipboard. Start the query.</li> In the Filter dialog box, paste the Clipboard contents into the Compare To box.</li></ol> </li> If you have an existing data source, use the AutoFormat command to replace straight quotes with smart quotes: <ol style="list-style-type: lower-alpha;"> Open your data source.</li> On the Format menu, click AutoFormat.</li> Click the Options button. Under Replace, select the "Straight Quotes with Smart Quotes" check box, clear any other check boxes, and click OK.</li> Click OK.</li> Click Accept.</li> Perform your query.</li></ol> </li></ol>

Method 2
Use MS Query. For applications like Fox Pro and Microsoft Access using ODBC, you may have the option to use MS Query if you have Microsoft Excel 5.0 installed. Click the option to use MS Query instead of the internal query engine in Word.

<div class="status_section">

STATUS
We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: merge data error message errmsg odbc sql query filter sort

Keywords: kberrmsg kbhowto kbbug kbinterop kbmerge KB125414

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.