Connecting to a mainfram DB2 table from access 2007.

[PuddinPie]

Hello all,

I know vba and I know mainframe. What I would like to know is how to connect to a DB2 table on mainframe and pull the data and put it into a access table.

I don't know ODBC really but it looks like it's what I'm going to need to use. If anyone has a tut or can walk me through step-by-step that would be great. Once I get the first one working then I will be off and running.

Thank you in advance.

 

[PuddinPie]

That's good information but unfortunately I think I need a full walkthrough or a tut.