Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel data base | Excel Discussion (Misc queries) | |||
Front-End for an Excel Data Base | Excel Discussion (Misc queries) | |||
Transfer Data from Excel 2000 to the Access data base | Excel Programming | |||
How do I fix my excel data base? | New Users to Excel | |||
Using excel as a data base | Excel Discussion (Misc queries) |