Hats off to Dick’s Clicks for detailing how to successfully add a parameter using Microsoft Query. By using MS Excel is it possible to create a database connection to another excel sheet and feed data through. The great thing about Dick’s Clicks solution is that you can use a variable in the spreadsheet to determine which data is imported (rather than have all the data piped through).

The tricky part about querying the data is that adding a parameter is not possible unless you add a criteria from MS Query. Otherwise if you try to do it from excel you are faced with a greyed out parameter button. Dicks solution has saved me again.