Re: Transfer Excel-file to AS/400

["Daniel Gross" <dg@xxxxxxxxxxxxxxx>]

-----Ursprüngliche Nachricht-----
Von: Staffan Lofberg <staffan.lofberg@netorom.se>
Datum: Mittwoch, 26. November 1997 17:33

>I have been trying to transfer an Excel-file from my PC to an AS/400.
>The best I have done so far is that everything went well except that the
>to first  fields didnt get filled with the right data.
>
>I have been using CA file transfer, CPYFRMPCD and FTP.
>
>Any suggestions?
>
>Staffan Lofberg

Hi Staffan!

I got the best results using the "CSV - Comma Separated Variable" format when
transfering data from Excel to AS/400.

Another very cool way I have testet is, to write a small Delphi program, that
uses two Datasources (one in the Excel file with MS ODBC 2.0 Pack and one on the
AS/400 with the CA/400 Win95 ODBC Driver) an the "BatchMove" component. This
solution has the advantage, that the tranfer can be done by simply double
clicking an icon on the desktop.

If you need a source example for this, mail me at dg@bingo.baynet.de !

Bye

Daniel Gross

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@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
+---