Re: Exprting data into Excel drops leading zero

That's a nice trick, but it's still somewhat more work than simply
downloading the data directly into Excel. Maybe I'm too lazy (didn't Larry
Wall say laziness is one of the "three great virtues of a programmer"?
:-), but since since DB2 knows it's a text field and CA knows it's a text
field, I think it would be _really_ handy if Excel could somehow get the
message that it's a text field without all that manual intervention.

But then, you could fill a book with things I think would be really handy
. . . . :-)

PC Technical Discussion for iSeries Users <pctech@xxxxxxxxxxxx> writes:
>What I just did (I've been playing with this almost all day) was to open
>up
>excel & then I went to || Data  ||  Get External Data  || Import Text File
>|| & imported the data (I had created a txt flat file first) that way. 
>Step
>3 of 3 of the wizard let me define the "type" of column each one is & I
>changed those columns that had numbers & I wanted to retain the leading
>zero
>from General to Text & the leading zeros were there.  No too much more
>work
>but it sure wasn't intuitive.
>
>I'm running Office 2000 so try it.
>
>Thanks - Dennis.
>



Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@xxxxxxxxxxxx