Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
LAC LAC is offline
external usenet poster
 
Posts: 2
Default Query parameters

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
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
MS Query - 2 Parameters cottage6 Excel Discussion (Misc queries) 2 July 17th 08 09:16 PM
Query Parameters Texas_Toast Excel Discussion (Misc queries) 0 January 11th 06 03:14 PM
Web Query Parameters raboo2u Excel Programming 4 January 11th 04 08:54 PM
Editing Query Parameters smunie Excel Programming 5 December 19th 03 05:47 PM
Query Parameters Jeff Excel Programming 1 November 18th 03 05:47 PM


All times are GMT +1. The time now is 02:29 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"