The xls4Oracle tool is an add-in for Excel, that enables two functions in Excel: SQL and Dataload.
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 Dataload function, you can load Excel data into an Oracle Database. You can also load data into Oracle Applications API’s and interface tables. The Dataload function is using data from several excel sheets in combination (data, mapping and dataload). 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.
