Using cells in excel to drive a query in access

[counterrabbit]

Heres what i want to do, im creating a interactive spreadsheet to evaluate a user. When they finish filling this in i can view what they have put, open another sheet and use their answers in a database eg they put choice A in a cell and this will be vlooked up on another sheet to give me a code. I will then bung these codes into a database query and produce some specific information

What i want to do is seamlessly show the results of a query actually in the excel sheet rather than creating a new query in access for each time a new user fills in the sheet, i want to report the query on the fly and in excel.

What would i do or where should i be looking to do this?

thanks

 

[Guus2005]

Assuming you have at least 5 years extensive Access knowledge, assuming that you worked with VBA the same time, you need a little nudge i the right direction.
Here's a nudge.

Create an Access function to return the value from the cel in the spreadsheet. Use this function in the where clause of your query and run it or export the result to Excel.

If my assumptions are wrong, your asking a lot with a little of information.

HTH

 

[Darth Vodka]

call a DAO.recordset and create the SQL on the fly

and use MATCH/INDEX instead of VLOOKUP