Tom, it may be over my head. As I read about this, it seems I need to have
ADO or DAO running (I don't know what they are, nor the difference) and perhaps
a database, Oracle or SQL. Is there a faq that takes me through ADO or DAO, so
I can get the big picture of what has to be happening?

Harry


On Fri, 18 Feb 2005 08:44:41 -0500, "Tom Ogilvy" wrote:

http://www.erlandsendata.no/english/...php?t=envbadac

--
Regards,
Tom Ogilvy


"Harry" wrote in message
.. .

Hello

I'd like to be able to press a button on an Excel sheet and start the
process of
running the MSQUERY function. I tried just recording keystrokes as a
macro,
clicking the following while in record mode:

Data/Import External Data/New Database Query/MS Access Database/Clicked on
Database Name

But nothing got recorded, it didn't work. I'm trying to save myself all
those
keystrokes by automating the task right up to the point in the query where
I
select which record I to import from the Access file.

I know enough about macros and VB to create a button and launch the macro,
but
I'm really new at this. Does anyone have any code that can do a query
from
Excel in an access file, pulling out a record of their choice?

Thanks

Harry