Solved

This data source contains no visible tables

Posted on 2014-09-10
5
2,310 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

820 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