Export MS Access query into Excel

Captain,

It's possible, I'm 90% sure, to do this using a DAO.querydef and it's "parameters" property. You could also rewrite your queries without parameters and then use the Query Manager in Excel. For help on both these ideas, you could start at http://www.dailydoseofexcel.com/archives/2004/12/13/parameters-in-excel-external-data-queries/.

When I was heavily into Access development I hit this problem a few times. Most simple queries are updatable, but others are not. You can tell by trying to edit the values in the result set. I would try your query first before assuming you can't do it.

There is one technique I used which gets around this issue quite well if all else fails, but is a bit of a pain to set up and maintain -- What you do is turn the select query you have into an append query, and save the record IDs only into a temp table. You can do this as part of a form open event (from memory - might need to use the me.requery) or better yet as part of code from the menu/button that got you to the form. Then you use a MUCH simpler query as the forms recordsource, just the temp table joined to the original table via the ID.

This should work, but you now also have some other tasks like emptying the temp table each time before/after you use it and it is not really multi-user friendly. If you need multiple users using it you need to add some sort of USERID to the table too. I hope this makes sense!