Database isn't definitive. but look at Mr. Erlandsen's site on using ADO

http://www.erlandsendata.no/english/...odao/index.php

--
Regards,
Tom Ogilvy


ims wrote in message
...
Dear all,

I have a database, I want to use excel as a searcher.
By inputting a key word excel will search the whole database and display
all
the records containing this key word.
What's the best and simplest way to do this?
Is there any sample program on the net for my easy reference.
Thanks.

ims