APEX

Hi,

I've searched the forum several times to try and find out how to import data from a .csv worksheet into an Oracle table. I have seen Vikas's post, but it's old and appears to no longer be supported. Also, I have been to other websites, like Denes Kubicek's. I have found bits and pieces, but it's like trying to put together a puzzle.

Can someone get me started on the right track concerning the main components that need to be developed, and briefly tell me how to do them? I think that's where I need to start.

This is what I need to do - -
Import data from a .csv worksheet that is uploaded via an Apex page, and then transfer/insert that data into an existing Oracle table. The Oracle table already exists, so the layout, etc. is already defined, and the user will be required to have the .csv worksheet's columns exactly match those in the Oracle table. Also, the imported data is for a specific location and month, so the user will enter the location and month on the Apex page and the application will put those 2 values into the Oracle table along with the .csv data. So, two fields will come from Apex, the other 20 fields will come from the .csv worksheet. I think that is possible to do, and I think I can handle that aspect once I understand how the basic steps work for importing from a .csv into an existing Oracle table.

There are two main aspects that I don't understand how to do. (I think these are the two main steps, correct me if I'm wrong.)
1. Use the File Browse field to put the .csv file into a specific location, folder, or table. How do I do this?
2. Then, when the .csv data is in a specific location I need to get it into the Oracle table. Sorry, but I don't know how to do this either.

I know the steps above are the guts of the application, but that's what I need help with. I can handle all the regular Apex aspects.

Any help anyone can provide will be greatly appreciated.

Thanks, Tony