Thread
:
Database Linked Spreadsheet
View Single Post
#
2
Posted to microsoft.public.excel.programming
Ardus Petus
external usenet poster
Posts: 718
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
Reply With Quote
Ardus Petus
View Public Profile
Find all posts by Ardus Petus