AS/400 data to Microsoft Access database

5 pts.
Tags:
AS/400 import/export
Microsoft Access
Microsoft Access import/export
In my business, I use an MS Access database to monitor inventory of my client and encode similar data to my client's AS400 system. I am asked by my client to simplify my job by encoding only in AS400 and have the data transferred to my Access database automatically to whatever method is possible. How is this possible? I am a simple access user and I do not understand much about other softwares or platforms. Is this possible? Is there a simple way? Thanks.
ASKED: April 21, 2009  8:11 AM
UPDATED: April 21, 2009  2:44 PM

Answer Wiki

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

Simple – AS/400 creates a comma delimited file on one of the “IFS” folders
You pull it from there into ACCESS.

Phil

Another option would be to configure an ODBC/OLEDB driver to your AS400 for your Access database. If you have real time access to your client’s AS400, this will give you realtime access to that data (allowing you to view the table(s) on the AS400 as linked tables in Access). There may be security implications for your particular implementation, but it’s worth discussing with the AS400 administrator. It sounds more complicated than it is; it takes about 5 minutes to set up the connection and link the tables, from there they’re just like Access tables… the advantage is once it’s connected you don’t need to “transfer” anything – it’s just there in your database whenever you connect/log in.

Mike

Discuss This Question:  

 
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

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