VBA ODBC connect to DB2
 

I would like to use Excel to retrieve data from a DB2 database.
Specifically, I would like to use VBA and connect to the database (which is
already available through ODBC) and use and SQL string to query the database.

Thanks for any help or sites that have code examples.

VBA ODBC connect to DB2
 

George wrote ...

I would like to use Excel to retrieve data from a DB2 database.
Specifically, I would like to use VBA and connect to the database (which is
already available through ODBC) and use and SQL string to query the database.

Thanks for any help or sites that have code examples.

Try searching the google groups Usenet archive for code exmaples. Suggested search:

http://groups.google.com/groups?q=gr...mming+ ado+db

Jamie.

--