Re: XCEL Spreadsheet transfer

[Jim Langston <jlangston@xxxxxxxxxxxxxxxx>]

Save it as type .PRN.  It gets saved as ASCII text with fixed column widths.
Then it imports real nice to DDS.

I go to Excel, save the file as .PRN, then FTP it from the AS/400.  Then CPYF
it to DDS I've laid out and it's ready to go.

Regards,

Jim Langston

Chris.Chambers@v2music.com wrote:

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