Export AS/400 to MS Access

5 pts.
Tags:
AS/400 import/export
export file
IBM iSeries
Microsoft 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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Rudedog
    i'd do a file transfer to an Excel file and let him/her import the file into Access. -sarge
    950 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following