Hi All,
I have a requirement where it is needed to upload an Excel file from cleint's system onto the Application servers. Once the Excel file is on server , then i have to put the data within the file into a staging table and further process the data.
I am using an ADF page for picking the file from client's system. I have designed the page and have used the component : InputFile for picking up the file from client's system. But i am not getting how to now put this on the Server directory location, not getting any dedicated component doing the same.
Please provide your inputs on this.
P.S. I am not very comfortable with converting the file into BLOB and storing in DB as the file again has to pour in its data into a staging table in server.
Please do also let me know if i can go for other alternatives.
Thanks,
Veena Shinde