On 16 Jan 2004 21:46:43 GMT in comp.databases.ms-access,
cl*******@aol.comNoSpam (Clint Stowers) wrote:
In article <g0********************************@4ax.com>, Trevor Best
<bouncer@localhost> writes:
Do you have an export specification in place that is still treating
this column as numeric?
I removed the SpecificationName just in case. Leading zeros in both the
orignal field and the formated field were removed.
However I found this to be the case when exporting to "MyFile.csv". When
exported to "MyFile.txt", both field maintain the leading zeros.
Currently checking to see if the software being export to will axcept an "txt"
extention. The text file should survice in that the data contains no true
numeric data. Just account and zipcodes. So I this point there may be no need
to reinvent the wheel.
Althought it would be nice to know why I can't place the leading zeros in the
"cvs" file.
I don't know if it has anything to do with Excel being the registered
application for opening .csv files but it has to be said, Excel is a
pile of poo when it comes to handling data. Only the other day I was
exporting data to Excel, which consisted mostly of dates. Being in the
UK all my settings are UK, including dates (dd/mm/yyyy) even so, Excel
would only treat the dates that were valid in US format (e.g.
03/04/2004) as dates and right aligned, all others (e.g. 13/01/2004)
were treated as text and left aligned.
--
A)bort, R)etry, I)nfluence with large hammer.