5 pts.
 Export AS/400 to MS Access
My auditor wants me to export files from my AS/400 to MS Access and I don't have a clue how to do that or if it can be done. I hope someone does.

Software/Hardware used:
iseries
ASKED: June 21, 2010  7:00 PM
UPDATED: June 29, 2010  11:40 PM

Answer Wiki:
You can import DB/400 files into a Microsoft Access using an ODBC connection to the data file. If you don’t have Microsoft Access then you could create CSV file and let him import that into Microsoft Access. It is not hard to import into MS Access as it is to export back to DB/400 file. Post a response if you need more details on setting up an import into MS Access.
Last Wiki Answer Submitted:  June 21, 2010  9:59 pm  by  hafwhit   1,145 pts.
All Answer Wiki Contributors:  hafwhit   1,145 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

i’d do a file transfer to an Excel file and let him/her import the file into Access.

-sarge

 950 pts.