see Mr. Erlandsen's site:
http://www.erlandsendata.no/english/...php?t=envbadac

for using ADO.

--
Regards,
Tom Ogilvy

"Bhavini" wrote in message
...
Hi,

Is there any simple method of opening a Access DB and
running a query from the database from an Excel sheet?

Thanks

B