Hi,
Are you trying to display the result of a query in a sheet?
If so, excel has a built-in feature that does just that and does not require
code:
1- in a new blank sheet
2- menu Data Get (or Import) External Data New Database Query. The
'Choose Data Source' dialog pops up.
3- make sure the checkbox 'Use the Query Wizard...' (at the bottom) is
checked. Choose MS Access Database and click ok. The 'Select Database' dialog
pops up.
4- browse to you db file and select it. click ok. The Query Wizard pops up.
5- The Query Wizard displays a list of tables and queries. Select one and
follow the wizard steps.

The wizard is good to build simple queries. Now, if yours is too complex
then in step 3 above, uncheck the 'Use the Query Qizard...'. In that case MS
Query opens (instead of the query wizard) and you should have much more
flexilbility there.

i hope this helps,
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"Chaplain Doug" wrote:

Excel 2003, Access 2003. I want to access a query within an Access database.
The database is called "FEOpen.mdb" and the Query is called "Projects List."
I guess I may be asking how to populate a recordset from Excel VBA using the
Access query. Any help will be appreciated. God bless and thanks.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org