Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MSQuery
Dear All,
I am about to import data from an odbc data source into excel worksheet using msquery. When I use a simple query from one table I can set up parameters for the query, but when I build a query using multiple joined tables / what I really need / the possibility of setting up a parameter disappears (the button is there but I press it in vain). Why ? Can someone tell me how to use parametrized query and what are the requirements of such query ? Also, how can I use a stored procedure to retrieve data when the procedure has a parameter ? Regards, Laszlo |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MSQuery
This page was helpful to me when I was trying to use parameters for the
first time. Hope it helps you too. http://www.nickhodge.co.uk/gui/datam...taexamples.htm -- Carlos "Lac" wrote in message ... Dear All, I am about to import data from an odbc data source into excel worksheet using msquery. When I use a simple query from one table I can set up parameters for the query, but when I build a query using multiple joined tables / what I really need / the possibility of setting up a parameter disappears (the button is there but I press it in vain). Why ? Can someone tell me how to use parametrized query and what are the requirements of such query ? Also, how can I use a stored procedure to retrieve data when the procedure has a parameter ? Regards, Laszlo |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MSQuery
Thanks, this page is a really good tutorial and as far as the query is so
simple as the example, it works. However, if you enter the SQL manually and it is a more complex one then MSQ states that it cannot be represented visually and from this point parameters cannot be used. "CarlosAntenna" wrote: This page was helpful to me when I was trying to use parameters for the first time. Hope it helps you too. http://www.nickhodge.co.uk/gui/datam...taexamples.htm -- Carlos "Lac" wrote in message ... Dear All, I am about to import data from an odbc data source into excel worksheet using msquery. When I use a simple query from one table I can set up parameters for the query, but when I build a query using multiple joined tables / what I really need / the possibility of setting up a parameter disappears (the button is there but I press it in vain). Why ? Can someone tell me how to use parametrized query and what are the requirements of such query ? Also, how can I use a stored procedure to retrieve data when the procedure has a parameter ? Regards, Laszlo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MSQuery editing source data? | Excel Discussion (Misc queries) | |||
MsQuery Documentation | Excel Discussion (Misc queries) | |||
msquery prompt for password | Excel Discussion (Misc queries) | |||
MSQuery "disappearing" | Excel Discussion (Misc queries) | |||
Multiple ODBC Database lik in one MSQUERY query | Excel Discussion (Misc queries) |