Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lac
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MSQuery editing source data? Dave H Excel Discussion (Misc queries) 0 April 21st 06 04:41 PM
MsQuery Documentation [email protected] Excel Discussion (Misc queries) 0 March 28th 06 04:55 PM
msquery prompt for password jocke Excel Discussion (Misc queries) 3 March 17th 06 09:07 PM
MSQuery "disappearing" taylorm Excel Discussion (Misc queries) 0 November 18th 05 09:08 PM
Multiple ODBC Database lik in one MSQUERY query Alain79 Excel Discussion (Misc queries) 0 September 13th 05 12:25 PM


All times are GMT +1. The time now is 12:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"