Related Tables - Access 2000

[Leonard Priestley]

My database programming experience to this point has been with Access. I
have been asked to handle a project which I would normally tackle using
Access. However, existing data is already in Excel, and the person
requesting the work is keen to retain Excel. Can someone tell me:
Is it possible to create related tables in Excel so that one table can be
used as a lookup for another? Also, is there any possibility of adding
something like a combo box or other drop-down list on an Excel sheet?

Leonard Priestley

 

[Nick Hodge]

Leonard

There is no true relational model as such in Excel. You do have the VLOOKUP
and HLOOKUP functions and similar. So for example you could have a Customer
Detail sheet and then on another sheet an invoice where an account number
could be entered and pull through from the customer detail sheet.

You can have combo boxes, etc in Excel, both from the forms or controls
(ActiveX) toolboxes and even ones under data>data validation...

Difficult to know if your project will suit...almost anything is possible in
Excel but some things are obviously better suited to other apps.

One other thing to bear in mind...Excel is not a good 'sharer' so if it is
multi user, consider some other way.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Leonard Priestley]

Thank you Nick,

I appreciate you taking time to answer. It has helped me to decide what to
do.

Leonard