Home » questions » Troubleshooting » Microsoft Query Error: "This data source contains no visible tables."

Microsoft Query Error: "This data source contains no visible tables."

2 minutes to read
70906 12

When you import data by using the Microsoft Query Wizard and choose Excel Files as data source, you may receive the following error message:

This data source contains no visible tables.

See following screenshot:

This data source contains no visible tables

Why?

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.

How to resolve this issue?

To resolve this issue, follow these steps:

  1. When you receive the error message listed in this article. Click OK.
  2. In the Query Wizard - Choose Columns dialog box, and then click Options.
    Microsoft Query Wizard
  3. In the Table Options dialog box, click to select the System Tables check box, and then click OK.
    System Tables
  4. Note that now you can see and select individual worksheets in your Excel data source.

Recommended content

  1. How To Correct Excel Formula Errors
  2. The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine
  3. How to reset the VBE windows to their default positions

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>

12 comments
  1. KI
    Kiran

    Thanks a lot! This worked like a charm.

  2. KG
    Kathy Gilbert

    Thx a million! This resolved my issue and I was able to create the queries I needed quickly.

  3. JE
    Jesson

    Thanks, problems are solved.

  4. NA
    Nancy

    so brilliant

  5. BI
    bilal

    very nice keep the good work

  6. MO
    Modesta

    They create their projects and projects onto it.

  7. MO
    Mostafa

    done the same, but still tables can not be viewed ?

    • MA
      Mark

      @Mostafa Did you ever get an answer, I’ve done this but still nothing displays ?

  9. تا
    تحميل اغانى

    Hi,I read your blogs named "Microsoft Query Error: "This data source contains no visible tables." - Excel How To" daily.Your writing style is witty, keep it up! And you can look our website about تحميل اغانى.

  10. RK
    raghu k p rao

    thanks its working

  11. KB
    Kunal Bhasin

    Thank you so much for the help it started working