Take a look at the bottom of the page at Nick Hodge's site. He shows how to
do pretty much exactly waht you want, using parameterized queries

http://www.nickhodge.co.uk/gui/datam...taexamples.htm


"Alistaire Green" wrote:

I have a Task which id like you to ponder and see if any of you know how to
accomplish it.

As we know whilst in Excel we can lookup information from another sheet or
Wookbook by using the Vlookup or Hlookup functions.

The task i have been given is to get data from an access database into a
excel document in the kinda way we do with Vlookup etc.

For Example, We input a Contract Number into a Cell and then the rest of the
information regarding that contract is automatically bought from an access
database to the excel document.