RE: [PCTECH] Exprting data into Excel drops leading zero

[Dennis Munro <DMunro@xxxxxxxxxxxxxxxxxxxx>]

I talked to Surveyor/400 people again & there are two places to create the
download.  One goes through a wizard that prompts for all the needed info &
the one that I was using did not because I was using SQL to get subsets of
the data.  They are in the process of rewriting the method I used to also go
through the wizard & that will fix the problem

Thanks - Dennis.

Dennis Munro

"I love deadlines. I especially like the whooshing sound they make as they
go flying by."
Dilbert's Words Of Wisdom

Badger Mining Corporation
www.badgerminingcorp.com
dmunro@xxxxxxxxxxxxxxxxxxxx
(920) 361-2388   Ext.141

-----Original Message-----
From: Adam Lang [mailto:aalang@xxxxxxxxxxxxxxxxxxxx]
Sent: Wednesday, February 25, 2004 7:48 AM
To: PC Technical Discussion for iSeries Users
Subject: Re: [PCTECH] Exprting data into Excel drops leading zero

My point is, why make things harder?  If you are using Excel to read the
data anyway, pull it down as the excel file and not as CSV.

In regards to the original question though, Surveyor/400 is doing the
"exporting to Excel" and it is doing it wrong, apparently.

----- Original Message -----
From: "Vern Hamberg" <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>
To: "PC Technical Discussion for iSeries Users" <pctech@xxxxxxxxxxxx>
Sent: Tuesday, February 24, 2004 7:36 PM
Subject: Re: [PCTECH] Exprting data into Excel drops leading zero


> I've a feeling that if one saved the result of an iSeries download to CSV,
> the leading zeroes would be stripped the next time it is opened.

_______________________________________________
This is the PC Technical Discussion for iSeries Users (PcTech) mailing list
To post a message email: PcTech@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/pctech.
The information contained in this e-mail message is confidential information
intended only for the use of the individual or entity named above. If the
reader of this message is not the intended recipient, or the employee or
agent responsible to deliver it to the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please immediately notify us by telephone, and
return the original message to us at the below address via the U.S. Postal
Service, and delete it from your computer.  Badger Mining Corporation  P.O.
Box 328  Berlin, WI 54923  920-361-2388