Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.programming
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.


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel data base foothillsuvwcfv Excel Discussion (Misc queries) 5 May 20th 06 10:47 AM
Front-End for an Excel Data Base Venkat Excel Discussion (Misc queries) 2 December 10th 05 05:50 AM
Transfer Data from Excel 2000 to the Access data base André Lavoie Excel Programming 1 September 28th 05 03:22 PM
How do I fix my excel data base? Millie Irene New Users to Excel 5 February 16th 05 07:33 PM
Using excel as a data base Nan Excel Discussion (Misc queries) 1 November 29th 04 01:21 AM


All times are GMT +1. The time now is 11:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"