Re: Data exchange between MS Access & AS/400

[Rob Berendt <rob@xxxxxxxxx>]

Denis,

We have a program that someone here wrote using Visual Basic that extracts data 
from one table in one file.  It's hardcoded but we'll send you the code if you 
want.
We call the program from a DOS batch file.  The DOS batch file is executed on 
the PC from the 400 using the command RUNRMTCMD, via the TCP option.  We do use 
Client Access to upload the file just because we like the mapping of that.  
Anyways the whole shooting match is executed from the 400.  When the developer 
here emails me the objects you'll need I'll forward them on to you.

Rob Berendt






DRobitaille@cascades.com on 03/08/99 10:02:59 AM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      

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