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

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • BharathP
    New Member
    • Apr 2008
    • 2
    #1

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

    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
    Tags: None
    • docdiesel
      Recognized Expert Contributor
      • Aug 2007
      • 297
      #2
      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

        Comment

        Previous template Next
        Working...