![]() |
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. |
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. |
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