Quote:
Originally posted by JChiappa
Bala, surely you will NOT find any facility built-in inside the database (i.e., in stored procedures, database triggers, etc) to read/write Excell data, so your choices will be :
a) call from your procedure an external executable program/routine to run Excell, or at least execute a program capable of read Excell data. To do it, you will use Java (if your db version is 8i), call an external routine (if version 8), or use dbms_pipes (if version 7). Find in the old messages of the forum more examples.
OR
b) using Excell, save the data in ASCII text-format, and use the facilities built-in in the database to read the text data.
[]s
Chiappa