The xls4Oracle tool is an add-in for Excel, that enables two functions in Excel: SQL and PL/SQL.
With the SQL function, you can write sql’s in Excel columns and extract data from an Oracle Database to Excel sheets. You can also use the apps initialize feature, enabling extracts from Oracle Applications session data (fnd_globals. org views, profiles etc.). Pls. try some of the sql sheets available here.
With the PL/SQL function, you can execute your PL/SQL with your Excel data into an Oracle Database. This enables you to load data into Oracle Applications API’s and interface tables. To do this the PL/SQL function is using data from several excel sheets in combination (data, mapping and plsql).
You will find 40 ready to use templates, they are all strait forward to customize or you can build new ones using the 4566 xls4Oracle template scripts.
The xls4Oracle tool is shareware and free to download. After the 30 day trial period, you should either buy or delete the program.
To start using the xls4Oracle tool pls. register and download.
