View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.links
John V
 
Posts: n/a
Default linking data in excel and access

I am trying to look up a reference value in a excel worksheet cell in an
access database to display, in excel, a value related to that reference.
i.e. enter a part number in a excel cell (reference). I want it to lookup
that part number in an access database query and to display the location of
the part in a cell on the excel worksheet