RE: Data exchange between MS Access & AS/400

[Ken Slaugh <ken.slaugh@xxxxxxxxxx>]

Write a macro with VB or VBA to open the Access table(s) and write the
info to the AS/400 as ASCII data to be converted with CPYFRMPCD command
or use http://www.cm-inc.com/AS400ole to send data via a AS/400 data
queue. I contract often to do these kinds of transfers, contact me if
you get stuck.

Ken Slaugh
Senior Programmer/System Analyst
AS/400 Professional Network Administrator/MSE
Specialist - Client Access/400
Chouinard & Myhre, Inc.

> -----Original Message-----
> From: Denis Robitaille [SMTP:DRobitaille@cascades.com]
> Sent: Monday, March 08, 1999 6:33 AM
> 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
+---