What is the best coding and connection to run against a DB2 database?
I can get something like to work but is it the best?
I want to loop through many files and SQLs so I need the program to wait for
the data to return before going to the next command.

With ActiveSheet.QueryTables
..Add(Connection:=ConnectString, Destination:=Range(DataTarget), Sql:=mySQL)
..Refresh (BackgroundQuery = False)
End With
I am going against an ODBC to a DB2 database and I was not sure if I was
doing this connection right or should I establish a an ADO connection use ,
create a querry, and return a record set? Do I need an ADO? Not sure how, as
I have seen some snipits of ADO, but not the whole thing so I am not sure
how to put it togheter.

The SQL works.

Confused