Re:Excel sprdsht to 400, Date: 1/9/99 ...Answer

[Kmh0421@xxxxxxx]

At 11:55 01/07/1999 - I wrote:
>First of all, thanks in advance for any help received. I have an Excel
>spreadsheet that has multiple columns totaling 322 characters. It had
multiple
>sheets, so I did a 'save as' and deleted the unnecessary sheets. I formatted
>the cell widths to exact whole numbers, and padded the first row fields out
to
>proper lengths with X's. So if field had 'ABCD' and it was a 10 char field, I
>padded it as 'ABCDXXXXXX'. I did a 'save as' different types. The only one
>that worked and FTP'd into a undelimited flat file on the 400 that I could
>copy to the correct file with *nochk was when I saved as Formatted Text,
space
>delimited. This saved it as a .prn file. All was well, except that it cut the
>length to 240, even though I had proper padding. My client has Hummingbird. I
>need this file uploaded asap.... can anyone help? 

First of all, thanks to all who replied. I downloaded Flatulance... and we are
trying it tomorrow at work. However my problem was solved today. After
spending way too long trying different options, and other people trying also,
a guy a work within an hour  transferred the spreadsheet to Access, formatted
all the columns properly (they all come in at 256), sent it up to 400...
Viola! All is perfect in my world once again. Thanks again.
Kathie

p.s.  Roger, I never heard back from you... did you try to run your program
over it?
+---
| 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
+---