DIGIT-ARC read-only archive · snapshot: July 23, 2026

DIGIT-ARC / Software / Software Q&A

Connecting ms excel to as400

3 posts · originally from https://geek.digit.in/community/threads/connecting-ms-excel-to-as400.134991/

V
vijayksingh08 Original post #1
Dec 13, 2010 at 5:40 PM
Hi,
I want to run queries in EXCEL and for doing so I want it to be connected to AS400 with the username and password. Have no clue how and where. Need some help here. I am not so familiar with programming part of EXCEL. BTW i am using EXCEL 2010.
V
vijayksingh08 #2
Dec 19, 2010 at 6:28 PM
c'mmon guys...any clue ?????/
E
enjoy #3
Dec 20, 2010 at 1:10 PM
vijayksingh08 said:
Hi,
I want to run queries in EXCEL and for doing so I want it to be connected to AS400 with the username and password. Have no clue how and where. Need some help here. I am not so familiar with programming part of EXCEL. BTW i am using EXCEL 2010.
Click to expand...

Assuming you have "IBM Data Server Driver for ODBC & CLI" installed. Create a ODBC DSN to the database, and provide connectivity/authentication information. Then you should be able to use that DSN in any kind of app.