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..
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:
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..