View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jabeen Jabeen is offline
external usenet poster
 
Posts: 1
Default Passing parameters from excel to access

Hi All,

I have a query in Access which expects a parameter. When I link the
access query to an excel using Data - Import External Data - New
Database Query and choosing this query, I get the message "Too few
parameters. Expected 1".

Any pointers to how I can resolve this by passing a parameter value
from excel (say, from a cell in the sheet) to the access query and
retrieve the results in the excel?

Do let me know

Thanks
Jabeen