<div>
The queries you don't see require parameters or are action queries.
</div>


The queries you don't see require parameters or are action queries.

<div>
They may also be hidden queries, which you can check by right clicking on a query and viewing its properties.
</div>


They may also be hidden queries, which you can check by right clicking on a query and viewing its properties.

<div>
There are no parameters required to run the queries. &nbsp;They are not action queries either in that they not updates or append queries either. &nbsp;These are simply complex views on the underlying data.<br />
<br />
None of the queries have the hidden attribute checked
</div>


There are no parameters required to run the queries.  They are not action queries either in that they not updates or append queries either.  These are simply complex views on the underlying data.

None of the queries have the hidden attribute checked

<div>
But this is not a solution, is it. One of your user perhaps has the same problem.
</div>


But this is not a solution, is it. One of your user perhaps has the same problem.

<div>
<div class="content wysiwyg-content">
I am trying to access data from an Access Database within Excel. &nbsp;I'm using the the Get External Data &gt;&nbsp;From Access button to link through to my access database. &nbsp;When I do this, I see some of the queries within the database but not all of them. &nbsp;Please could someone explain why the are not all visible and how I make the one's i need visible.<br />
<br />
My Access DB is in accdb file format<br />
I'm using Excel 2007 too.<br />
<br />
I'm not that familiar with VBA and am looking for a solution that doesn't involve coding.<br />
<br />

</div>
</div>


I am trying to access data from an Access Database within Excel.  I'm using the the Get External Data > From Access button to link through to my access database.  When I do this, I see some of the queries within the database but not all of them.  Please could someone explain why the are not all visible and how I make the one's i need visible.

My Access DB is in accdb file format
I'm using Excel 2007 too.

I'm not that familiar with VBA and am looking for a solution that doesn't involve coding.



Not all access queries visible in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.