WD2002: Excel Worksheets Not Available When Accessed with MS Query (286891)
The information in this article applies to:
This article was previously published under Q286891 SYMPTOMS
When you work with a document and you try to open a Microsoft Excel file with Microsoft Query, you may receive the following error message:
This data source contains no visible tables.
CAUSE
This issue occurs because the ODBC driver used to connect to the data source perceives the worksheets in your Excel workbook as system tables and does not display them. System tables are objects in database files that are not displayed by default.
WORKAROUND
To work around this issue, follow these steps:
- Start Microsoft Word, and then open your document.
- On the Tools menu, point to Letters & Mailings, and then click Mail Merge Wizard.
- Click Letters, and then click Next.
- Click Use Current Document and click Next.
- Click Use an Existing List, and then click Browse.
- In the Select Data Source dialog box, on the Tools menu, click MSQuery. Note that Microsoft Query starts and the Choose Data Source dialog box is displayed.
- Click to select Excel Files and click OK.
- In the Select Workbook dialog box, browse to your Excel file and click OK. Note that you receive the error message listed in the Symptoms section of this article.
- Click OK. In the Query Wizard - Choose Columns dialog box, click Options.
- In the Table Options dialog box, click to select the System Tables check box, and then click OK.
Note that now you can see and select individual worksheets in your Excel data source.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
| Modification Type: | Major | Last Reviewed: | 4/3/2001 |
|---|
| Keywords: | kbbug KB286891 |
|---|
|