This content has been marked as final. Show 8 replies
Yes, you can give a form to User, where user can upload a excel file ( in predefined format) directly into database. Just have a look on following article
Hope will solve your problem..
I think this utility provided by Vikas will give you a more generic solution.
Thanks very much for the replies.
These seem to work for CSV files but they do not appear to work with XLS files. The files I'm trying to load are in MS Excel 2.1 and we cannot get them in another format (they come from and old system which we cannot change).
Any ideas, apart from converting the files manually?
I could write a conversion component using VB/COM but I would rather not go down this route. I also tried using SQL Loader as well but it cannot read XLS files either.
Message was edited by:
Can you please provide us the login credentials and the workspace name for checking the functionality.
What is the uname and pwd to view this example?
Vikas example app have new id. You can find it from here
The routine you are looking at deals with CSV files.. Try looking at this blog entry, it will need modification to meet your table layout..: http://avdeo.com/2008/05/21/uploading-excel-sheet-using-oracle-application-express-apex/
Never Surrender Dreams!
If this question is answered, please mark the thread as closed and assign points where earned..
Or try our solution