Running Access queries from Excel without opening the Access DB 1

[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, or a query qith subqueries, 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

 

[gwoman]

In Excel I am clicking on a toolbar object that has 2 little spreadsheets with a pencil and the tool tip reads Edit Query ...
This brings up the dialog box I am referring to ... is this not the QBE?

 

[SkipVought]

Yes, this opens the QBE Editor. Does it have the Menu Items that I referred to?

Skip,

_[red][/red]

 

[gwoman]

No ... the form title reads ... Query Wizard - Choose Columns ... it has 2 windows with the >, >>, <, << operands in between ... the left window says Available tables and columns: and then lists the tables and columns with a + to the left of each ... the right window says Columns in your query: and when I click the + and expand the table or query I can then select the columns I want using the operands above ... there are some buttons at the bottom (some are greyed out) Preview Now, Options..., <Back, >Next, Cancel ...

Sorry for soooo much detail ...
Thanks ...

gwoman

 

[SkipVought]

Forget all that.

Uncheck the Use query wizard checkbox.

Skip,

_[red][/red]

 

[gwoman]

OK ... Did that and got what appears to be the real QBE =)
I went to add tables ... and could see my tables and queries ... went to add my union query and got an error "cannot access 'my union query'" ....

Thanks

gwoman