Solved

This data source contains no visible tables

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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

739 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