RE: Excel Transfer

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

Keith,

This topic comes up from time to time. I'd recommend you look into CPYTOIMPF
(copy to import file) which can create a delimited file (comma, tab, etc) in
the IFS. There are some quirks with this command depending on the version of
OS400 you are running. The archives should contain additional details.

hth,
Eric DeLong

-----Original Message-----
From: keith.nolan@dubport.ccs.ie [mailto:keith.nolan@dubport.ccs.ie]
Sent: Thursday, May 03, 2001 12:31 PM
To: MIDRANGE-L@midrange.com
Subject: Excel Transfer


Hi all,

If I want to automate the transfer of a database file from our AS/400 into
an excel file on a folder how do I get the transfer command 'CPYTOPCD' to
translate into an Excel File like you can do on the Client access file
transfer....

TIA..

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