|
Yes, I did. But went back to double check and re-ran it. Now opening in notepad does show all the digits and it is in quoted string. 342,2008,0,3869285,"S","9992508894550907","",25.0,0.0,0.0,20030606,0,0 I must have inadvertently saved the file after opening it with excel (damn auto save) and before looking at it thru notepad. Guess I just have to live with the fact that it's an excel limitation. I guess the users will buy that (after all, what else can they do about it) since it is a M$ product [...ducking and running...] But seriously, if any one has any other suggestion other that prefixing it with a character, I am all ears (or eyes as the case may be). -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Fisher, Don Sent: Wednesday, June 25, 2003 5:02 PM To: 'Midrange Systems Technical Discussion' Subject: RE: CPYTOIMPF and numerics > 15 Digits That is interesting. Are you using a string delimiter (STRDLM)? Donald R. Fisher, III Project Manager Roomstore Furniture Company (804) 784-7600 extension 2124 DFisher@xxxxxxxxxxxxx <clip> However, if I open it with notepad, 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. <clip> _______________________________________________
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.