View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K Dales[_2_] K Dales[_2_] is offline
external usenet poster
 
Posts: 1,163
Default Front-End for an Excel Data Base

My opinion only:

First, if users need to query extensively, Excel is not the best database
manager. There is no real query ability in Excel, just various lookup
functions that have limitations.

But, if you do wish or need to use Excel:
- My first choice would be Access, not because it is the greatest but
because it is designed to work with Excel. Set up a link to your Excel data
sheet and then you can use all the features of Access to work with it: set up
a form for data viewing/entry or set up queries, etc.
--
- K Dales


"Venkat" wrote:

Greetings,
I'm hoping to create a Data Base with Excel, but would like some to
use other program as the front-end. Which would the Ideal Front-end for
the same? (Appending & Querying must be preformed with ease.)
Thanks,
Venkat.