RE: CPYTOIMPF and numerics > 15 Digits

[Joe Giusto <jgiusto@xxxxxxxxxxxxxx>]

Yes, I saw those comments in the archives.  However, if I open it with note
pad, here is one of the lines:

30,1610,2,5251255,V,9992509516956650,83656,14,14,0,20030606,0,0

the 9992509516956650 should be 9992509516956651 and is listed as a 16 alpha
in the database file.



 -----Original Message-----
From:   midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]  On Behalf Of Fisher, Don
Sent:   Wednesday, June 25, 2003 4:15 PM
To:     'Midrange Systems Technical Discussion'
Subject:        RE: CPYTOIMPF and numerics > 15 Digits

Are you opening the file using Microsoft Excel by any chance?  If so, it has
a problem with numbers having more than fifteen digits.  I believe there is
some discussion in the archives on this subject. 

Donald R. Fisher, III
Project Manager
Roomstore Furniture Company
(804) 784-7600 extension 2124
DFisher@xxxxxxxxxxxxx

<clip>
When trying to do a CPYTOIMPF to create a .CSV file, we have an alpha field
that is 16 long and most times contains all numbers.  This field gets
converted as a numeric, which is o.k. but the last digit is always replaced
by a zero.  
<clip>
_______________________________________________