Run an Access query from Excel - not showing all queries

[gwoman]

I am working in Excel where I have a drop down list of object names ... when I select an object from this list ... I want it to go to an Access DB that holds the data, run a query and return the data to excel with out opening up the DB. My problem is this ... when I try to set what query I want to run I don't see all the queries in my DB. I can only see Select queries and tables ... why do the other queries (i.e. union, update, etc.) not show up? The only way I can see and run those is if I actually open the DB and I don't want to have to do that.
I would greatly appreciate any help and/or suggestions ... thanks!

gwoman

 

[AlexCuse]

Update queries don't return any data. How would you show them in Excel?

If you need to get around the union thing, just set up another query like this:

select * from MyUnionQuery

You might get more info on this in one of the Excel forums though.

Good Luck,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[gwoman]

Thanks Alex .... have a great day!
gwoman

 

[SkipVought]

Hi,

In the window where you can select your tables, hit the OPTIONS bitton and be sure that VIEWS is checked (I have all FOUR checked)

Skip,

_[red][/red]