Thank you Mr Hatmaker for sharing the "Parameterized Query with excel." I have watched the videos on youtube (beyond excel) describing the function and I have a few questions.
1-I am looking for the syntax for "contains". I am searching for the syntax to place in the criteria field that would return all cities that contain the text "al" ..something similar to: City LIKE '%al%' (I have tried Like '%'++'%' and many others but nothing seems to work)
2- Can we change the SQL statement in the properties window.