Hello All,
With the release of Oracle APEX 4.1 and onwards we have a
Data Load Wizard through which we can upload an MS Excel file to Oracle Database table through an
APEX Application (where the data load utility is available to end users).
I have searched many options for a micro level excel to oracle mapping solutions but got confused and not getting one assuring solution.
Now, my
question is:
My organization gives an excel sheet based form to newly joined employees through e-mail.
The excel sheet is specifically structured to get the information from the employee.
What I mean by
micro level excel to oracle mapping is that I want to upload
only one record
of this employee in the excel sheet by mapping specific excel cells to the table in oracle database.
My thought process for solution is:
1) Design a VB Macro in the excel sheet to convert it into header and data formatted comma separated (.csv) file, where header is the first row in the csv file that maps to columns in the table and the second row is the data record to be uploaded.
2) Now, the csv file in the first step can be used to upload to oracle database through various uploading utilities available in APEX or Oracle Database.
I want forum expert's views whether this is possible or any good solution is out there already!
Technical Specifications :
<ul>
<li>
Full APEX version : Application Express 4.1.0.00.32</li>
<li>
Full Database version : Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production</li>
<li>
APEX Web server architecture : Embedded PL/SQL Gateway(EPG)</li>
<li>
Browser(s) and version(s) used : Mozilla Firefox 10.0.2, Google Chrome 17.0.963.56</li>
<li>
Operating system : Red Hat Enterprise Linux 5 (32-bit)</li>
</ul>
Thanks in advance!
Kiran