This data source contains no visible tables

Folks,
Using the attached 2010 workbook I've been trying to establish a connection so I can use MSQuery. The attached workbook, tab labeled "Sales List" is my data source (the attached workbook is clean and is what I've been using- I've copied and pasted values into this new workbook making sure that the Range Manager was empty). I'm selecting the correct driver for Excel, yet when I "Select a default table for your data source" there is nothing there. I've researched through the Internet and tried all what's been suggested, even working through Word's Mail Merge. I've tried with the file saved in an Excel 2003 format. The results are always the same.
This problem is not unique to 2010 - I've have the same problem on my 2013 machine getting the same results - "This data source contains no visible tables".
I do not why I'm having this problem or how to make this work. My OS is Windows 7 on both machines.
No tablesNo visible tablesDynamicDataValidation.xlsx
Frank FreeseAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rory ArchibaldCommented:
In the MSQuery wizard, you can click Options and choose the 'System Tables' option. This will then show the sheets as Tables.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Frank FreeseAuthor Commented:
Rory,
When I select "Getting Data from Other Sources" - "From MSQuery" the first thing I see is this:
Choose Data SourceI have been selecting  "New Data Source" and "OK"
The next thing I see is this:
[embed=file 871500I complete items 1 and 2 then click "Connect"
ODBC setupNameDataSource.png
0
Frank FreeseAuthor Commented:
I did not mean to submit - I wasn't done yet so ignore the above please
0
Frank FreeseAuthor Commented:
Rory,
 When I select "Getting Data from Other Sources" - "From MSQuery" the first thing I see is this:
Choose Data SourceI have been selecting  "New Data Source" and "OK"
 The next thing I see is this:
Name Data SourceI complete 1 and 2
From there is click "Connect" and complete this:
ODBC setupI then complete this:
Select Workbookand click OK twice and finish here:
select tableYou commented "In the MSQuery wizard, you can click Options and choose the 'System Tables' option. This will then show the sheets as Tables"
I looked at all the options available in this process and could not locate "choose the 'Systems Tables' ". Where have I gone wrong?
0
Frank FreeseAuthor Commented:
Found it! Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.