Try Data>External Data>Create Query

Search Help for Parametrized Query

HTH
--
AP
"jwilliamson" <jwilliamson.27wtly_1147798803.9855@excelforum-nospam.com> a
écrit dans le message de news:
jwilliamson.27wtly_1147798803.9855@e...rum-nospam.com...
>
> I have never done any programming in excel, I am a pretty experience
> programmer but here is my dillema. I need a spreadsheet, that when you
> type a value in a cell, it looks up the value in a database (it is the
> primary key of the table) and populates other columns in that row with
> the data associated with that value. Is this something feasable to
> program in excel? If it is, how would I go about getting this to work.
> Thanks.
>
> -Jon Williamson
>
>
> --
> jwilliamson
> ------------------------------------------------------------------------
> jwilliamson's Profile:
> http://www.excelforum.com/member.php...o&userid=34493
> View this thread: http://www.excelforum.com/showthread...hreadid=542593
>