AS/400 data to Microsoft Access database
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.
Software/Hardware used:
Software/Hardware used:
ASKED:
April 21, 2009 8:11 AM
UPDATED:
April 21, 2009 2:44 PM
Answer Wiki:
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
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
