[ krul @ 17.06.2005. 21:52 ] @
Exportujem tablu u csv file, i tom prilikom gubim "vodece nule" u koloni koja mora biti sa vodecom nulom. Svasta sam dosad probao schema.ini, query na bazi table sa Format (polje,"00") i export querija umesto table koristeci docmd.transfertext ali nista. Excel je ponekad prepametan pa mi svojim formatingom zezne podatak.
Ostaje kao zadnje resenje da nakon exporta kroz kod otvorim fajl pa onda onda formatujem sto mi se i ne cini vrlo civiliziranim resenjem. Any ideas?
[ krul @ 17.06.2005. 23:34 ] @
Evo kako sam resio pomenuti problem:

If you have a table for export in which leading zeros and spaces have significance AND that file will only be viewed in Excel, then you can use an Excel specific convention in those fields where leading zeros or spaces should be preserved (in Excel).

To implement this fix, double quote each field with leading zeros or spaces and place an equals sign (=) directly ahead of the first quote, like this:


="08075"

Link:
[url]http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm[/url]