0's getting truncating during Import

S

samdani_md

Hi,

I have a requirement like this.

Thru PLSQL i will wirite data to excel file.
Im using tab as seperator for columns.

There is one column which i will have characters.but all the characters
were numbers.
For Example i will have data like this 01234,02345,0012,0234
But if im opening the excel File the leading 0's are getting
truncated.
I need actual data to be preserved in Excel.
For this i have appended single quote for that column.but it was the
deviation from my requirement.

Can any one help me in this context

Regards,
Md.Sam
 
Top