Solved

This data source contains no visible tables

Posted on 2014-09-10
5
2,474 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

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…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

691 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