ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Front-End for an Excel Data Base (https://www.excelbanter.com/excel-programming/347595-front-end-excel-data-base.html)

Venkat

Front-End for an Excel Data Base
 
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.


K Dales[_2_]

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.



[email protected]

Front-End for an Excel Data Base
 
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



All times are GMT +1. The time now is 02:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com