Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

how to upload a txt file to application server's folder in excel format?

Former Member
0 Kudos

Hi Gurus,

i got a requirement to transfer data into application server.

how to upload a <b>txt file</b> to application server's folder in <b>excel</b> format?

while transfering data into excelfile from text file...the numeric fields are

not displaying the exact values in excel sheet.


in text file the values are:01/01/2007

in excel sheet it is displaying: 1/1/2007.

for both month and date it is not showing the '0'.

Please help me.


Former Member
0 Kudos

just chage the operating systems settings then it will come as 07/19/2007

Former Member
0 Kudos

go to regional settings and there change the format which ever u want.

ex: 09/11/2007 or 9/11/2007 ok