DavidM wrote:
I guess using SQL directely versus the GUI loses Excel's ability to
prompt
for parameters

Yes, if MS Query cannot interpret the SQL according to its own SQL
syntax. When this happens you get the message 'Can't display
graphically' (whatever than means) and you will not be able to use its
parameters functionality. Syntax (ODBC or otherwise) to call a stored
proc have this effect.

Jamie.

--