Solved

This data source contains no visible tables

Posted on 2014-09-10
5
2,230 Views
Last Modified: 2014-09-10
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
0
Comment
Question by:Frank Freese
  • 4
5 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 40314830
In the MSQuery wizard, you can click Options and choose the 'System Tables' option. This will then show the sheets as Tables.
0
 

Author Comment

by:Frank Freese
ID: 40315146
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
 

Author Comment

by:Frank Freese
ID: 40315147
I did not mean to submit - I wasn't done yet so ignore the above please
0
 

Author Comment

by:Frank Freese
ID: 40315175
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
 

Author Closing Comment

by:Frank Freese
ID: 40315220
Found it! Thanks
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question