RE: Data exchange between MS Access & AS/400

["Allen, Stuart" <sallen@xxxxxxxxxxxx>]

You can use an ODBC link between the access tables and a file on the 400 -
this would enable you to either update the data on the fly, or create an
update query in access so that you can choose when to update.  You will need
the ODBC drivers installed that are a part of Client Access.  Open the
"32bit ODBC" applet in Control Panel, select System DSN and Add.  Select the
Client Access driver.  Change the default libraries box to include the
library that contains the file that you want to update.  Go into Access,
then add a new table, of type link.  When the dialog box opens, change the
"files of type:" box to ODBC.  You should now get a list of all files in
that AS400 library.  Select the one you are interested in.  You can then use
this as you would any other access table to query/update etc. 
I would advise working with a test copy of the file untill you are
comfortable with what you are doing - ODBC works using SQL - it's all too
easy to screw up!  There are some pretty good books about using ODBC with
Access - I can't recommend one off the top of my head but a trip to the
local library would be worthwhile if you are interested in using this area
more.

Hope this helps,
Stuart


> -----Original Message-----
> From: Denis Robitaille [SMTP:DRobitaille@cascades.com]
> Sent: Monday, March 08, 1999 2:33 PM
> To:   MIDRANGE-L@midrange.com
> Subject:      Data exchange between MS Access & AS/400
> 
> Hello all,
> 
> Here is the situation: We have a production system written in MS access
> (include raw material receiving, comsumption ...). This data base is on an
> NT sever. I need to transfer (about 3 times a day) from the access data
> base to the AS/400 the raw material receiving and comsumption transactions
> and from the AS/400 to the access data base the new orders.
> 
> Since i dont know access very much, i need help on how to exchage
> information between the 2 platform. I tought i could simply FTP files
> between the 2 systems but it seems that all the access tables are
> contained in a single files.
> 
> If anyone can give me some hints as to how to do this or as where i can
> get more info, i would apreciate it very much.
> 
> Thank you
> 
> Denis Robitaille
> Cascades Inc
> 819 363 5187
> fax 819 363 5177
> DRobitaille@cascades.com
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---