Connecting ms excel to as400

vijayksingh08

Right off the assembly line
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.
 

enjoy

Journeyman
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.

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.
 
Top Bottom