• Subject: Re: XCEL Spreadsheet transfer
  • From: Jim Langston <jlangston@xxxxxxxxxxxxxxxx>
  • Date: Wed, 10 Nov 1999 14:29:02 -0800
  • Organization: Conex Global Logistics Services, Inc.

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

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact [javascript protected email address].