CODEWITHSUNDEEP
excelodbcibm-midrange
Matthew
Matthew

Reputation: 1

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

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

Upvotes: 0

Views: 1844

Answers (3)

Dmitriy Kuznetsov
Dmitriy Kuznetsov

Reputation: 21

you can access the data in multi-member files via FTP. For example /QSYS.LIB/your_library.LIB/your_file.FILE will be considered a directly by FTP. Depending on the data structure you may be able to do it directly from Excel.

Upvotes: 0

danny117
danny117

Reputation: 5651

Download a file multiple members to excel

create a logical file over the physical file with all members. Download the logical file with excel data connection.

Hope this helps.

Upvotes: 0

Charles
Charles

Reputation: 23813

No.

Multi-membered files are generally not supported by any SQL tool.

However
You can always CREATE ALIAS myname FOR MYLIB/MYTABLE(MYMBR)

Then use myname to access from Excel.

Upvotes: 0

Related Questions