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:
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:
- When you receive the error message listed in this article. Click OK.
- In the Query Wizard - Choose Columns dialog box, and then 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.
Matur nuwun
Thanks a lot! This worked like a charm.
Thx a million! This resolved my issue and I was able to create the queries I needed quickly.