By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,882 Members | 2,489 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,882 IT Pros & Developers. It's quick & easy.

How to access DB2 database using Microsoft access(SQL passthrough)

P: 2
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
Apr 4 '08 #1
Share this Question
Share on Google+
1 Reply


docdiesel
Expert 100+
P: 297
Hi,

if you've got the DB2 driver (runtime client) installed, catalog the remote DB2 database on your windows system and then create a system ODBC entry via the Windows control center.

Open your access database, select the menu "insert" and then "table". Now you're given the possibility to link a table from an external source. Open the "type" drop down box and go to the bottom where you'll find "odbc databases". Then select the data source you formerly created and choose the tables you need.

Regards,

Bernd
Apr 4 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.