Pass parameters to MS Query from Excel spread sheet RRS feed

  • 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
    Saturday, October 20, 2018 3:04 PM


All replies