How to export data from ms-access or excel to IBM DB2 I-Series database?

Question

I have some data in access(and excel) and I don't find a Free and not-really-hard-way to do it... any help?

I have excel and access 2003*

Michael Sharek · Accepted Answer · 2011-06-27 15:24:27Z

3

Add the DB2 iSeries database as an ODBC datasource in Windows. You should be able to do this with the Client Configuration Assistant that comes with the DB2 Client for Windows.

Open up your data in MS Access, you should be able to export it to an ODBC datasource from there. Good luck.

answered Jun 27, 2011 at 15:24

Michael Sharek

5,0792 gold badges32 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mike Wills · Accepted Answer · 2011-06-27 15:40:59Z

0

Another option is to export the data to a CSV file, then use the "Data Transfer to iSeries" utility that comes with Client Access.

answered Jun 27, 2011 at 15:40

Mike Wills

21.3k29 gold badges99 silver badges153 bronze badges

Collectives™ on Stack Overflow

How to export data from ms-access or excel to IBM DB2 I-Series database?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related