Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing parameters from excel to access
When you've selected the query and the fields and the sorting When you select Data/New query you first get a wizard to select the databse, table and columns. When that is done the dialog "Import Data" comes up. where you can indicate where the data needs to go.. At the bottom of that dialog there is a button "Parameters". (it is greyed out when the query has no params, but it should be available when your query HAS (and needs) params. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Jabeen wrote : 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing parameters from excel to access
And just to add, here is a page on how to do it (including screenshots):
http://nickhodge.co.uk/gui/datamenu/...taexamples.htm Nick Hodge's site. -- Regards, Tom Ogilvy "keepITcool" wrote in message .com... When you've selected the query and the fields and the sorting When you select Data/New query you first get a wizard to select the databse, table and columns. When that is done the dialog "Import Data" comes up. where you can indicate where the data needs to go.. At the bottom of that dialog there is a button "Parameters". (it is greyed out when the query has no params, but it should be available when your query HAS (and needs) params. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Jabeen wrote : 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing Excel Objects As Parameters | Excel Programming | |||
Passing Excel Objects As Parameters | Excel Programming | |||
Passing parameters | Excel Programming | |||
Passing parameters | Excel Programming | |||
Passing parameters to UDF | Excel Programming |