RE: Excel's 240 character limit

[Joel Fritz <JFritz@xxxxxxxxxxxxxxxx>]

I like fixed length text, but I'm wondering if you might be able to export
the files as DIF or comma delimited.  You won't run into the 240 character
limit, but there may be other problems for your particular situation.
Client Access file transfer handles DIF and csv pretty well.  If you're not
using Client Access, you can ftp a csv file to an ifs file and use
cpyfrmimpf.  


> -----Original Message-----
> From: Rogers, Leland [mailto:Leland.Rogers@fisi.cendant.com]
> Sent: Tuesday, February 29, 2000 2:05 PM
> To: 'MIDRANGE-L@midrange.com'
> Subject: Excel's 240 character limit
> 
> 
> Does anyone experience the 240 character per line limit problem when
> exporting Excel files as Formatted Text (Space Delimited) 
> (.prn).  We get a
> lot of disks/tapes from clients with Excel files that need to 
> be cleaned up
> and exported and then uploaded to our 400. However, when we 
> save as a space
> delimited .prn file any columns over the 240 character limit 
> wrap and the
> file is useless.  We have developed procedures for a 
> workaround, but it is
> time consuming.  Microsoft gives a workaround with a macro 
> written in Visual
> Basic that is two pages long.  Is that our only fix?
> 
> Leland Rogers
> Systems Administrator
> FISI-Madison Financial
> +---
> | 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
+---