Now you need some VBA code.
You can use ADODB

HTH
--
AP

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

I understand how to make a query for myself, but I need to prepare this
spreadsheet in such a way that the user can open it, in column A type
all of the primary key values they want to see data for, and have it
fill in columns B-I with the data from the database about that primary
key value. So that they can print it and show it to other managers. How
would I go about doing that? Is it possible?


--
jwilliamson
------------------------------------------------------------------------
jwilliamson's Profile:
http://www.excelforum.com/member.php...o&userid=34493
View this thread: http://www.excelforum.com/showthread...hreadid=542593