I'm trying to write a query to import from an excel file. I can use the wizard but am looking to eventually create a procedure.
pseudo: select * from (C:\Documents and Settings\JL04638\Desktop\report.xlsx)
Not really a SQL Developer issue. You'll get more feedback in the SQL and PL/SQL forum.
There are a number of things to bear in mind.
You need to investigate things like external files, XMLDB, Application Express.
The PL/SQL space has a FAQ that might have an answer for you
Re: 5. How do I read or write an Excel file?