I recieve a spreadsheet(.xls) from business user on daily basis via email by 10.00 AM daily. Right now
- We manually download the file from email.
- Place it in a folder
- Then upload sheet data into a oracle table. (There is existing java setup application when clicked on submit upload ,it loads data into a table).
I am looking for assistance where
Case 1) " PL-SQL reads the attached excel file automatically around 10.30 from my outlook email and loads data into table " .
Case 2) If Case 1 is not implementable via PL-SQL then looking for " PL-SQL reads the excel file from specified folder in my WINDOWS 2007 automatically around 10.30 and loads data into table "
Environment details : Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production CORE 11.2.0.3.0
Production TNS for Linux: Version 11.2.0.3.0 -
Production NLSRTL Version 11.2.0.3.0 - Production
*Also we dont have access to UNIX-servers to place the files and think about utilizing unix shell script flexibility to achieve this.