SQL*XL - Customer Case Study


Qualserv Corporation


QualServ is one of US's top five manufacturers and distributors of foodservice equipment, supplies and services to chain and multi-unit organizations. We are also a leading supplier of custom fixtures to major retail chains.




Requirements to meet

Extract data from Oracle to Excel, allow users to do mass updates in Excel and then re-import back into Oracle.

Issues to tackle

We need to give users a tool to update mass amounts of data efficiently.

Approach taken

Customized spreadsheet using VBA and SQL*XL to allow users to query needed data, make updates and then re-import the modified data back into Oracle.


We are still in the process of implimenting SQL*XL, but so far so good.