excel

[swakoo]

is it possible for pl/sql to read excel(.xls) file?
if no any ways to do it or is there any tools to do it? i can't seems to find any tools as i am using a unix environment.
thanks in advance.

 

[Marco Kalter]

There is no direct way to do this, but you can save the .xls file in CSV format, and use the Text Importer to import the .csv file.

 

[swakoo]

can give more details? i am a newbie with all the tools i am currently using..
thanks..
still a student..

 

[Marco Kalter]

I assume you want to read tabular information from an Excel sheet into an Oracle table? If so, save the Excel sheet in CSV format.

Next, go to Tools > Text Importer, open the CSV file, define the field configuration, select a target table, and import the data. See chapter 15.7 in the User's Guide for more details.