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 to make the connection and I am able to access schema, table, views from Excel using data connection. But the problem is that some tables have multiple members in it and the excel's pulling data from what I am guessing as the first member that excel sees when all the important data are in other member files...
Is there anyway I could select specific members and download data of that specific member directly to excel?
I can do this when I use IBM's data transfer program, but I would like to find out if it's possible to do directly with excel..
Thanks!
Matt
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 to make the connection and I am able to access schema, table, views from Excel using data connection. But the problem is that some tables have multiple members in it and the excel's pulling data from what I am guessing as the first member that excel sees when all the important data are in other member files...
Is there anyway I could select specific members and download data of that specific member directly to excel?
I can do this when I use IBM's data transfer program, but I would like to find out if it's possible to do directly with excel..
Thanks!
Matt
Comment