Access-->Excel Connect, Query not Showing on list

[jurbin]

Hello, I am currently having an issue with my Access Database that I tried to connect with Excel. For some reason when I try to connect my Excel Table to my Database, the list of tables and things pops up, but the query that I created is not on the list. It is all tables, but my query does not show up. Does anyone know how to make the queries show up so I can just refresh excel and automatically update my data?

[trevor40]

post a sample please....

[jurbin]

post a sample please....

Here is my table and query list in access


Here is what I get when I try to connect

[trevor40]

What you have provided shows nothing about how you connect, I need to see the code or connect string to see how you are connecting, or are you using the link table command? Could be it only imports into an existing table not a query. use a make table from your query and use that or get back to me with more details.

[June7]

I have no problem seeing queries with the Excel external data wizard. Cannot replicate issue. If you want to provide db for analysis, follow instructions at bottom of my post. I will see if Excel and Access 2010 behave differently with your db.