Re: Data exchange between MS Access & AS/400

["Roger Pence" <rp@xxxxxxxxxxxxxx>]

>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.
>

Denis--

Consider using CA/400's OLE DB stuff (Project Lighting). The OLE DB redbook
has an Access example. It works surprisingly well. With this approach, you
don't have to go through CSV, data transfer or FTP hassles.

rp


+---
| 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
+---