Access DB2 data using Microsoft Access

[BharathP]

Hi,

I need to transfer data of one of the table in DB2 to Microsoft Access. I tried using DBOP data source using Configuration assistant in DB2 and SQL passthrough in Microsoft Access. I think I'm doing some mistake in the configuration. Can anybody pls tell me the exact steps to configure it. Or is ther any other process to accomplish this task?

Thanks in advance,
Bharath

[Stewart Ross]

Hi. You will need to use an Open Database Connectivity (ODBC) driver to link to your DB2 table. I have no experience of this for DB2 myself, but there is a technical article from IBM at the following link which provides guidance on setting up such a link:

http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0605bhogal/

-Stewart