You are currently offline, waiting for your internet to reconnect

You may not access Excel worksheets by using MS Query

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

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:
  1. Start Microsoft Word, and then open your document.
  2. In Word Microsoft 2002, point to Letters & Mailings on the Tools menu, , and then click Mail Merge Wizard.

    In Microsoft Office Word 2003, point to Letters & Mailings on the Tools menu, and then click Mail Merge.

    In Microsoft Office Word 2007, click Start Mail Merge in the Start Mail Merge group on the Mailings tab. Then, click Step by Step Mail Merge Wizard.
  3. Click Letters, and then click Next.
  4. Click Use Current Document and click Next.
  5. Click Use an Existing List, and then click Browse.
  6. 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.
  7. Click to select Excel Files, and then click OK.
  8. 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.
  9. Click OK. In the Query Wizard - Choose Columns dialog box, and then click Options.
  10. 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.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Properties

Article ID: 286891 - Last Review: 01/29/2007 13:41:41 - Revision: 2.2

Microsoft Office Word 2007, Microsoft Office Word 2003, Microsoft Word 2002 Standard Edition

  • kbbug kbnofix KB286891
Feedback
d=1&t=">