AS/400-to-Excel downloading

[Chris Sharman]

> -----Original Message-----
> From: Jeff Hoffman [mailto:wonicon@optushome.com.au]
> Sent: 14 July 2002 01:06
> To: powerh-l@lists.swau.edu
> Subject: RE: AS/400-to-Excel downloading
>
>
> G'Day
>
> Just to add my 2 bits worth.
>
> If you want more then 256 chars, try this
>
> Quiz will need to be two pass
>

Alternatively, you can put the offending line break in a column of its own,
and use longer lines:

When you can't fit any more fields on the 255 char line, put
'","' skip '","' ...
Excel will then join the lines as it loads, putting the line break generated
by skip in as a column of its own. A quick and dirty way beyond the 255 char
limit.

Chris



-----------------------------------------------------------------------

Any views expressed in this message are those of the sender and not
necessarily those of CCA Group.  The unauthorized use, disclosure,
copying or alteration of this message is forbidden.  The contents of
this message may be confidential and/or privileged, copyright CCA Group
and are intended solely for the use of the individual or entity to whom
they are addressed.  Whilst this message has been scanned, CCA Group
cannot guarantee that it is virus free or compatible with your systems
and accepts no responsibility for any loss or damage arising from its
use. The recipient is advised to run their own anti-virus software. If
you receive this message in error please contact
postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
from your computer systems.