Re: Excel spreadsheet to 400, Hummingbird

Kathie,

We just released version 2.00 of our Alliance CrossData/400 product that
supports importing CSV and tab-delimited files to AS/400 database files.
It handles numeric formats like zoned, packed, binary, and floating
point. Several other data types are supported, too. You can get more
information and download it at:

   http://www.patownsend.com

Patrick
Kmh0421@aol.com 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?
> Thanks so much;
> Kathie
> +---
> | 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
> +---

-- 
IBM AS/400 communications, FTP automation, and network security
software and consulting services.

http://www.patownsend.com

begin:vcard 
n:Townsend;Patrick
x-mozilla-html:FALSE
org:Patrick Townsend & Associates, Inc.
adr:;;7700 Earling Street NE;Olympia;WA;98506;US
version:2.1
email;internet:townsend@patownsend.com
title:President
tel;fax:(360) 357-9047
tel;work:(360) 357-8971
note;quoted-printable:Software and consulting services for the IBM AS/400. =0D=0ASpecializing in AS/400 communications, FTP automation =0D=0Aand network security. 
x-mozilla-cpt:;0
fn:Patrick Townsend
end:vcard