Exporting a table data to csv file
Posted on 2012-04-03
I am having a stored procedure which creates a csv file and insets data into the file from the table.
one column of the table is a number(4) and it requires a formatting of hh:mm
I did that formatting and this table also has -ve values.
Like -23:59, -03:56 etc..
On exporting to CSV file, when opened in note pad or word pad, the records are written properly without any problem but on opening with excel file, there is a problem.
For the rows which should contain records like -23:59 etc it i showing #value and when i clicked on the #value, it shows =-23:59..which means it is taking that number as a formula.
I need to know how to overcome this problem, all i wanted is that -23:59 and similar records should be available as it is required.
Please help resolve(I am using UTIL file package to write the data to csv file)