View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Use excel as a searcher

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