APEX

Hi.
I have to developed a transaction processing application in Apex.

We receive a Excel file every day conatining approimately 20,000 rows/records.
(None of the fileds contain more than 200 characters)

So I need to give the user an option where by he enters the filename and its path
and the file gets uploaded into the table.

I went thru the how-to document for upload spreadsheet data.
But here the user has to copy and paste data and the data should not be greater than
32K characters. But our excel file contains more than 4Lac characters.

I also searched the forum but found solutions of using the upload utility in SQL Workshop. But doesn't seem to be user friendly.

Please advice. Its urgent.

Thanks in advance.
Ameya.