Get external data - how to stop table list from being displayed on connect?

[P Adhia]

Hello,

I am trying to use Excel's get external data feature to view a
Mainframe DB2 table using ODBC connection. 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.

Thanks

P Adhia

 

[Jamie Collins]

(e-mail address removed) 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/ExternalData3.htm#CreateVBA

For more control in VBA code, consider using ADO.

Jamie.

--