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!

Converting .xls to .csv file using pl/sql or any other method ( oracle 9i)

user_anumosesMay 14 2015 — edited May 14 2015

Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.8.0 - Production

Report Builder 10.1.2.0.2

ORACLE Server Release 10.1.0.4.2

Oracle Procedure Builder 10.1.2.0.2

Oracle ORACLE PL/SQL V10.1.0.4.2 - Production

Oracle CORE    10.1.0.4.0    Production

Oracle Tools Integration Services 10.1.2.0.2

Oracle Tools Common Area 10.1.2.0.2

Oracle Toolkit 2 for Windows 32-bit platforms 10.1.2.0.2

Resource Object Store 10.1.2.0.2

Oracle Help 10.1.2.0.2

Oracle Sqlmgr 10.1.2.0.2

Oracle Query Builder 10.1.2.0.2 - Production

PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production)

Oracle ZRC 10.1.2.0.2

Oracle XML Developers Kit 10.1.0.4.2 - Production

Oracle Virtual Graphics System 10.1.2.0.2

Oracle Image 10.1.2.0.2

Oracle Multimedia Widget 10.1.2.0.2

Oracle Tools GUI Utilities 10.1.2.0.2

I had seen a very old post from 2009.

Converting .xls to .csv file using pl/sql

I know it s a long time but just wanted to know if there is a way for converting excel to .csv.

i have a directory say 'F:\purple_top\'. I will be getting .xls file into this directory. I need to change it to .csv and load into oracle external tables. Any thoughts or advance coding on this from 2009 till now?

This post has been answered by gaverill on May 14 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 11 2015
Added on May 14 2015
2 comments
625 views