I imported data from AS/400 database file into an Excel sheet, using ODBC. I selected Microsoft query in order to retrieve data. How can I export data into AS/400 database file?
I created ODBC connection inorder to import data from As400 Database file , how can export or update data into AS400 database file . Is the above procedure is not correct , can you suggest me the correct way for Import and export database file into excel .
There are a few possible ways of doing this data transfer. Is this going to be a manual or automated process? If there is a script that is going to handle this, what language is it written in?
I am not using any scripts as per my knowledge , i am jsut using odbc connection to import the data .I am asking how to export the data .
Steps for Import the data : Create a odbc connection and Open excel and select Data option ->then From other sources -> Microsoft query ->:Select odbc connection created -> after few mandatory steps you can import the data
The only way I have exported data from Excel to the AS/400 or i-Series is using the Client access add in. With this you can export your data. I have better luck with .CSV file formats rather than .XLS or .XLSX. This add in makes life a lot easier.
@melindabeal, First take spool file report as a text file using iseries navigator & then import it right into excel. When using excel text Import wizard to import as/400 data contained in spool files make sure you select fixed width.
@melindabeal, you could also use the as/400 addin for Excel. This let's you import a file directly or even write a SQL script to retrieve the DB2 data from the i-Series. info on the addin can be found here.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: 8 Replies
@melindabeal, First take spool file report as a text file using iseries navigator & then import it right into excel. When using excel text Import wizard to import as/400 data contained in spool files make sure you select fixed width.