SQL*XL

Product name: SQL*XL

Supplier: Linker IT Consulting Limited

Classification: Free LITE version (limited features), Commercial FULL version

Target User: DBA’s, Developers and Analysts

Oracle version(s): 7.x, 8.x, 8i, 9i

SQL*XL is an addin for Microsoft Excel that provides a full featured link to the database. A new menu item will be added to Excel through which SQL can be sent. SQL*XL allows you to fetch data straight into your spreadsheet and does a good job at decently formatting the data. SQL*XL allows you to integrate values from Excel into the SQL (e.g. select * from emp where sal > :A1)

Inserting data to the database was never easier. SQL*XL allows you to send a whole spreadsheet full of data to the database with a few mouse clicks. If required SQL*XL can generate a small form in which you can insert one row of data at a time.

SQL*XL is well documented and comes with a full help system. It supports Excel macro recording (SQL*XL’s API is defined in the help file) and other advanced Excel features. Finally SQL*XL is shipped with an installer and uninstaller.

For general enquiries, please link to:
http://www.oraxcel.com/profile/form_enquiries.html

For technical support enquiries, please link to:
http://www.oraxcel.com/profile/form_support.html

Author: Gerrit-Jan Linker

Author

Marks out of ten

Comments

Anonymous comments will not be accepted.

Anything the referee would like to say about the tool. Do try to be factual, with concrete examples if you wish to complain about defects, or indulge in fulsome praise or particular points. A tool which was useless for one person may be near-perfect for another, so pure value judgements do not help.