Saying I have a database really says nothing very useful.
Where is the database. Gocush has assumed it is in an excel spreadsheet. I
have assumed it is external to excel - but even assuming that, where is it -
access, sql server, oracle, something else?
Maybe I should have said the term database is not self defining.
--
Regards,
Tom Ogilvy
"ims" wrote in message
...
Dear Tom,
What's the meaning of "Database isn't definitive"?
I find the path you given me can't help me a lot.
regards,
ims
"Tom Ogilvy" ¼¶¼g©ó¶l¥ó·s»D
...
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