Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to convert .xls to CSV fiel

venkatMay 3 2008 — edited May 3 2008
Hi,

I executed one query into Toad and save as a .xls file.

actually i want to .csv file. so, I converted .xls file into .csv file.

problem is my date like --
column1 column2
0034569 -A

After conversion data changed as a ---
column1 column2
34569 ?Name

zeros are not in column1 and if i open into excel sheet,
column2 is came =--A, so it shows into cell like ?Name.
if i open into notepad column2 came properly but column1 is same problem.
And also i tried create report from TOAD but data not in the report.

How to create .csv file. i have one tool TOAD. And also i tried create report from

TOAD but data not in the report.

Thanks Reagrds
Venkat
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 31 2008
Added on May 3 2008
3 comments
574 views