• Subject: Re: Data exchange between MS Access & AS/400
  • From: Rob Berendt <rob@xxxxxxxxx>
  • Date: Mon, 8 Mar 1999 10:19:44 -0500

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


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].