Update Data In Excel Change As400 Data
Posted : admin On 17.08.2019I recently started a job at a company that still uses AS400 and need some help!
- Odbc Connection To As400
- How To Extract Data From As400 To Excel
- Update Data In Excel Change As400 Data Software
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.
AS400 to MS Excel - Importing Data. I am trying to setup up some MS Excel Files which will import data from an AS400 using the following methods but i am getting mixed results. In Excel i am using the menu 'Data / Import External Data / New Database Query'.
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
3 Answers
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.
Odbc Connection To As400
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.
danny117danny117How To Extract Data From As400 To Excel
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.