View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default Database Linked Spreadsheet

Try DataExternal DataCreate Query

Search Help for Parametrized Query

HTH
--
AP
"jwilliamson" a
écrit dans le message de news:
...

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