RE: Electronic Data Transfer

Save them as CSV into a IFS directory and then CPYFRMSTMF command to get it
into the iSeries.  Unless the layouts are exactly the same, it's probably
best you copy them to a temporary location and then SQL the data into your
master files.

HTH

-----Original Message-----
From: bpcs-l-bounces+nabennis=chello.nl@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+nabennis=chello.nl@xxxxxxxxxxxx]On Behalf Of
Taher.Mallah@xxxxxxxxxxxxx
Sent: Wednesday, March 23, 2005 7:05 PM
To: BPCS-L@xxxxxxxxxxxx
Cc: david@xxxxxxxxxxxx
Subject: [BPCS-L] Electronic Data Transfer


Hi Everyone;

Due to the migration from our ERP To BPCS version 6.04
We want to transfer data from Excel Spreadsheet into the BPCS Database.
The Master Files are:
·       Item Master.
·       Customer Master.
·       Vender Master.

Any suggestion will be highly appreciated.

Thanks.


Taher Mallah
System Analyst
e-Business Architect
  514-822-7035 / 514-822-7041
  514-822-7994
  taher.mallah@xxxxxxxxxxxxx