Answered by:
Pass parameters to MS Query from Excel spread sheet

Question
-
I want to use the data in an Excel spreadsheet to pass query parameters to MS Query. I've found several useful examples on the forum but in each case, they pass only a single parameter based on an individual cell in the spreadsheet. In my situation, I want to use a column of cells where each cell represents the same query parameter but has a different value, i.e. executing an SQL OR statement. I hoped to do it in MS Query because I have little to no programming. Any suggestions would be greatly appreciated. - Bill
- Moved by Yuki Lou-MSFT Monday, October 22, 2018 5:48 AM
Saturday, October 20, 2018 3:04 PM
Answers
-
- Proposed as answer by Richard MuellerMVP, Banned Monday, October 22, 2018 1:07 PM
- Marked as answer by Richard MuellerMVP, Banned Monday, October 29, 2018 1:30 PM
Monday, October 22, 2018 6:12 AM -
I don't understand why they moved this thread but also try over here.
https://social.technet.microsoft.com/Forums/en-US/home?forum=excel
Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management
Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.- Proposed as answer by Richard MuellerMVP, Banned Monday, October 22, 2018 1:07 PM
- Marked as answer by Richard MuellerMVP, Banned Monday, October 29, 2018 1:30 PM
Monday, October 22, 2018 1:01 PM
All replies
-
Hi Bill,
This forum(Excel for Developers) is for development issues related to Excel Object Model and your problem is more related to Excel product, I will move your thread to Where is the Forum For…? so someone could tell you where to go ask your question.
Thanks for understanding.
Best Regards,
Yuki
MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread.
- Edited by Yuki Lou-MSFT Monday, October 22, 2018 6:21 AM
Monday, October 22, 2018 5:48 AM -
- Proposed as answer by Richard MuellerMVP, Banned Monday, October 22, 2018 1:07 PM
- Marked as answer by Richard MuellerMVP, Banned Monday, October 29, 2018 1:30 PM
Monday, October 22, 2018 6:12 AM -
I don't understand why they moved this thread but also try over here.
https://social.technet.microsoft.com/Forums/en-US/home?forum=excel
Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management
Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.- Proposed as answer by Richard MuellerMVP, Banned Monday, October 22, 2018 1:07 PM
- Marked as answer by Richard MuellerMVP, Banned Monday, October 29, 2018 1:30 PM
Monday, October 22, 2018 1:01 PM