Importing data from an access query into excel

[1992]

In Excel 2010, I go to Data -> From Access -> database.mdb -> hit OK -> hit OK

What pops up is a list of all the tables in my access database when what I really want to be able to do is select a query instead of a table and display the table of results from the query in excel.

Is there a way to do this quite smoothly and easily?

Thanks a lot

 

[AccessBlaster]

Here is one way of doing it. I use Access 2000

1. Create a new query with all the fields you need, I saved mined as qryExportContacts.
2. Create a new macro I saved mine as macExportContacts
In the Action type: OutputTo
Object Name: qryExportContacts
Object Format: Microsoft Excel (*.xls)
3. Create a new button from the wizard select Miscellaneous, run macro
select your new macro and finish.

 

[spikepl]

As far as I remember, you can only import queries that do not require interaction (i.e. do not pick up values for criteria from forms). Such queries should appear in the list of objects avaliable for import.