AS400 - Data downloading to Excel from AS400 table with multiple members

[arunara]

I recently started a job at a company that still uses AS400 and need some help!

So currently we do not have any BI tool to access system data files directly, so I'm trying to connect AS400 to excel using ODBC and download/display AS400 data directly to excel.

So I accomplished...

[scxy1234]

Not sure if this is the right place to post. We are trying to access a system i (v6 r1) from the Tableau analytics tool using ODBC on a Windows workstation. The errors we get are the following:

Unsupported function listing...

This ODBC driver does not support all the...

[swaps400]

Hi,

I have one machine where ODBC is set up to connect to AS400.
Upon executing the macro, it gives authorization error. While on the other machine , user is able to run the macro and load data from excel.

Can you please suggest what could cause error? I do not...