SQL*XL - Customer Case Study


InfoPower International Inc. Canada


Founded in 1983 in Canada, InfoPower International Inc. began as an Independent Enterprise Software Solutions developer, using the original integrated set of Oracle's Rapid Application Development and CASE tools. In the years that followed, InfoPower's development effort has evolved into a complete set of comprehensive software modules known as ERPDBOŽ Enterprise Solutions.




Requirements to meet

The primary requirment is for data migration. Once we have data in Excel we use SQL*XL to load direct to Oracle tables and then redistribute as necessary. Additionally there are user developed Excel reports which with the assistance from SQL*XL can be directly driven from the database.

Issues to tackle

Ease of use with PL/SQL and its power to manipulate any data.

Approach taken

Provide Excel spreadsheets with embedded SQL*XL.


Everything worked fine.