Fetch DB2 table data into MS-Excel
-
Hi All, I need to query the DB2 database tables and populate the Excel work sheets (one sheet for single table) using VB Macro. Also, I need the validation in the Excel sheet itself. (DB2 database credetials) Can you pls help me to get start? Thanks, Jeyakumar :)
Jey
modified on Wednesday, April 16, 2008 6:11 AM
-
Hi All, I need to query the DB2 database tables and populate the Excel work sheets (one sheet for single table) using VB Macro. Also, I need the validation in the Excel sheet itself. (DB2 database credetials) Can you pls help me to get start? Thanks, Jeyakumar :)
Jey
modified on Wednesday, April 16, 2008 6:11 AM
Jay_se wrote:
I need to query the DB2 database tables and populate the Excel work sheets (one sheet for single table) using VB Macro. Also, I need the validation in the Excel sheet itself. (DB2 database credetials)
I believe Excel VBA does ADO, so you should be able to connect to the DB2 database and do your stuff. For connection information, look up www.connectionstrings.com[^].
-
Jay_se wrote:
I need to query the DB2 database tables and populate the Excel work sheets (one sheet for single table) using VB Macro. Also, I need the validation in the Excel sheet itself. (DB2 database credetials)
I believe Excel VBA does ADO, so you should be able to connect to the DB2 database and do your stuff. For connection information, look up www.connectionstrings.com[^].