Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
WD2000: Errors When Using ODBC to Insert Microsoft Excel Worksheet
Article ID: 245652 - View products that this article applies to.
This article was previously published under Q245652
When you attempt to insert a Microsoft Excel worksheet into a Word document or when you attempt to attach a Microsoft Excel worksheet as a data document to a mail merge main document using the Excel Files via ODBC (*.xls) driver, one of the following error messages appears:
Word was unable to open the data source.
Open Database Connectivity Error: Syntax error in query. Incomplete query clause.
When you click the Details button, the following error message appears:
ODBC Error: [Microsoft][ODBC Excel Driver] Syntax error in query.
Incomplete query clause.
SQL State: S1000
Return Code: SQL_Error
You did not select a worksheet from the Select Table dialog box. (To locate this dialog box, select the Select Method check box in the Open Data Source dialog box, select the Excel Files via ODBC (*.xls) driver in the Confirm Data Source dialog box, and then click OK.)
Use the following procedure to insert a Microsoft Excel worksheet as a database in Word:
NOTE: Be sure that the Microsoft Excel ODBC driver is installed before you follow this next procedure. If the Microsoft Excel ODBC driver is not installed, re-run Setup and install the ODBC driver.
(http://support.microsoft.com/kb/213866/EN-US/ )WD2000: Word Ignores First Record in Excel Data
(http://support.microsoft.com/kb/212314/EN-US/ )WD2000: How to Use Microsoft Excel Data Source for Mail Merge
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.