RE: XCEL Spreadsheet transfer

[Joel Fritz <JFritz@xxxxxxxxxxxxxxxx>]

If you have files with dds to receive the contents of the spreadsheets, try
saving them as csv (comma delimited) files and uploading them.  You'll have
to download the as/400 file to create a field description file.

Another option is (if you're at v4r2 or above I think) cpyfrmimpf.  You can
copy the comma delimited file to a file in the ifs and use cpyfrmimpf to
copy it into a database file.

Another option is to continue as you have but format the columns as fixed
width.  If you download the file from the 400 (an empty one will do fine) to
create the fdf, you can do the transfers directly and skip the source file
step.

> -----Original Message-----
> From: Chris.Chambers@v2music.com [mailto:Chris.Chambers@v2music.com]
> Sent: Wednesday, November 10, 1999 10:21 AM
> To: midrange-l@midrange.com
> Subject: XCEL Spreadsheet transfer
> 
> 
> When using Client Access can anyone tell me which is the best 
> way to transfer an
> XCEL spreadsheet and create a database file on the AS400. 
> What should I save the
> XCEL file as or can it be transferred directly as it is - if 
> so what parameters
> are needed in the details section.
> 
> Currently I save to ASCII text space delimited then transfer 
> to a source file
> which then gets a CPYF *CVTSRC performed. However I have 
> spreadsheets whose
> columns vary in width and have to adjust accordingly - I am 
> sure there is an
> easier way but no manuals on site - help!
> 
> Regards,
> 
> Chris
> 
> 
> +---
> | 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
+---