How can I have MS Query reference SQL on an excel worksheet? I would like to have the parameter for my union query where I have to enter a range for each statement ( between '20100408' and '20100414'). If I enter my SQL in the MS Query SQL window it cannot be represented graphically. Then when I try to add the paremeter through data connections... I can only enter the parameter for my first select statement.
I am using Excel 2007 and am open to a VBA alternative, but I will need handholding on the execution(s)
Thanks a million