Front-End for an Excel Data Base

V

Venkat

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.
 
G

Guest

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.
 
V

venkatsharma

Thanks Dales,
It's a Simple Project for a Co-op to manage their Address DB which is
there in Excel. They R reluctant to change their DB from Excel. Think I
will go with Access.
- Venkat
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Front-End for an Excel Data Base 2
Access Form Refresh 1
Excel front-end and Access back-end? 9
Creating a front end application to sql data set 1
Excel as front end and SQL Server as back end 0
VBA front end for Excel 3
Do you need MS Access to query on an Access table? 1
Is it feasible to use Excel as a database front-end? 5

Top