Need a stored procedure to read data from an excel sheet and insert into a table - using oracle 8i
Posted on 2004-03-31
I need a stored procedure that will help me to read an excel sheet on the hard disk.
then i need to insert this data into a table..
i am using oracle 8i, i have heard this is possible, but don't have any clue how to work upon this.
PS: Also i cannot create a dsn on the excel sheet as this may differ w.r.t user.
Experts Please Help ....