wrote ...

How can I get MSQuery to
stop tyring to show me all the tables that exists upon connecting to
database? The problem is, Mainframe DB2 has more than 500,000
tables/views defined and connection just dies before it can bring back
the list. The table of interest to me itself is small and I'd like to
code the SQL directly.

You can use VBA to do this and this avoid opening the MS Query UI. For
details, see Dick Kusleika's site:

http://www.dicks-clicks.com/excel/Ex....htm#CreateVBA

For more control in VBA code, consider using ADO.

Jamie.

--