Connecting ms excel to as400

[vijayksingh08]

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.

[vijayksingh08]

c'mmon guys...any clue ?????/

[enjoy]

Originally Posted by vijayksingh08

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.