Related Tables - Access 2000

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

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
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Leonard Priestley" <priestly@ihug.co.nz> wrote in message
news:e9c5rp$qmr$1@lust.ihug.co.nz...
> 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
>
>

Thank you Nick,

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

Leonard

"Nick Hodge" <nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS> wrote in message
news:u04LwoKqGHA.220@TK2MSFTNGP05.phx.gbl...
> 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
> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>
>
> "Leonard Priestley" <priestly@ihug.co.nz> wrote in message
> news:e9c5rp$qmr$1@lust.ihug.co.nz...
> > 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
> >
> >
>
>