Re: Excel Question

[pnelson@xxxxxxxxxx]

I second going the SEQUEL route. I just finished doing a conversion to a 
Windoze server package. That package required that data be imported in 
Excel format. I used SEQUEL for everything. No RPG, no CLP. I built one 
script that sent the data to the IFS in xls format. The Windows import 
software mapped a drive to the IFS and started its thing.


Paul Nelson
Arbor Solutions, Inc.
708-670-6978  Cell
pnelson@xxxxxxxxxx





Mike Eovino <meovino@xxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
09/22/2004 02:31 PM
Please respond to Midrange Systems Technical Discussion
 
        To:     Midrange Systems Technical Discussion 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Subject:        Re: Excel Question


On Wed, 22 Sep 2004 10:16:11 -0500, Goodbar, Loyd (ETS - Water Valley)
<lgoodbar@xxxxxxxxxxxxxx> wrote:

> Personally, we've had very few complaints about providing CSV files.

You're lucky, as we've had a ton of them.  If Excel sees a field in a
CSV file with nothing but numbers in it, it treats it as a numeric
(even if you put the value in quotes).  Not good when you're sending
files with zip codes in them (New Jersey's zips begin with zeros). 
I'm not sure how it treats tab-delimited files, perhaps it deals with
them better.

We bought Kemetech's conversion utilities (www.kemetech.com).  Pretty
cheap and they work well.  We later bought SEQUEL from ASC which also
has Excel export capability.

If you have a Java guy around, I'd check out the HSSF/POI stuff. 
That'll give you control over the output far beyond anything a
conversion utility can give you.

Mike E.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.