Select the product you need help with

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

SYMPTOMS

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:

Case 1

Word was unable to open the data source.

Case 2

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

Back to the top | Give Feedback

CAUSE

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

Back to the top | Give Feedback

WORKAROUND

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.

On the View menu, point to Toolbars, and then click Database. The Database toolbar appears.
Click the Insert Database button on the Database toolbar.
Click the Get Data button.
Select the Microsoft Excel workbook you want to open, select the Select Method check box, and then click Open.
In the Confirm Data Source dialog box, under Open Data Source, select Excel Files via ODBC (*.xls), and then click OK.
In the Select Table dialog box, click Options.
In the Table Options dialog box, select the System Tables check box, and then click OK.
In the Select Table dialog box, under Table, select the worksheet you want to insert, and then click OK.

NOTE: Each sheet name is appended with a dollar sign ($) symbol, such as Sheet1$, Sheet2$, and so forth.

For additional information about using an Excel file as a data source in a Word mail merge, click the article number below to view the article in the Microsoft Knowledge Base:

213866

(http://support.microsoft.com/kb/213866/EN-US/ )

WD2000: Word Ignores First Record in Excel Data

212314

(http://support.microsoft.com/kb/212314/EN-US/ )

WD2000: How to Use Microsoft Excel Data Source for Mail Merge

Back to the top | Give Feedback