Importing queries from Access to Excel

Hello Sarah,

Not entirely sure what your trying to achieve. If you have set up a query in Access, for example to display all the customers in London, then the results can be exported to excel from within the database in Access, which may be a better option.
To do this you must run the query you want to export, then go to the External Data Ribbon, in the Export section, Select Excel. Following the instructions in the dialog box.

Alternatively, the method your doing from within should work fine. Ive tried it several times and all queries show up. Sorry without seeing your setup I cannot answer why they do not appear in your list?

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer