Good News!! (to which everyone says "Finally!!", then mutters "...maybe
he'll go away...") I finally found the answer he
http://support.microsoft.com/kb/q235340/ . I added "SET NOCOUNT ON" into
the query and away it runs!! Woohoo!! But now I have more questions:

1. How do I get the VBA to clear the spreadsheet before the query so that
previous results are not mixed with more current results?
2. How I get my VBA to retain the formatting that I have set in place?

TIA!