How can I get leading zero when I'm exporting to MS Excel?
I have query like this one:
select '01234'
from dual
In preview I see 01234 but in MS Excel value is 1234. Zero is somehow lost. I tried with CSV and through Get external data in MS Excel and everything is fine. The problem is only when I'm exporting directly to the MS Excel.
Is there some workaround for this? If not can you do something in your OLE (I suppose that you are using OLE to do export to MS Excel ?)
I'm using QueryReporter 2.0.4.180, MS Excel 2000 (9.0.3821 SR-1), W2000 SP4.
Thanks,
Davor.