Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to read data from Excel file(.csv) and how to insert in to two separate tables when file upload?

Mani kantaDec 28 2017 — edited Jan 3 2018

Hi All,

I am using APEX 5.1.3.00.05 version.

Database: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Please suggest me the solution to insert data into two separate tables which data actually needs to fetch from Excel sheet(.csv) file.

I tried with upload file(Data load definition as fig below) component in APEX to insert data. But, it is getting mapped with only one table and inserting in to it.

pastedImage_0.png

When I upload Excel(.csv) file it is getting uploaded successfully. But, mapped with only one table and inserting data into it.

pastedImage_1.png

As per my requirement I want to insert data into two separate table from the same Excel sheet(.csv) file.

Please suggest me the better approach to achieve my requirement.

Regards,

Manikanta
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 31 2018
Added on Dec 28 2017
#apex-5-1, #apex-discussions
8 comments
4,393 views