SQL*XL
3 provides a bridge between databases and Microsoft Excel.
With SQL*XL you have a single interface to all your databases.
Convenience and productivity is our focus. Working with databases
was never easier...
SQL*XL 3 provides an easy to use bridge between Excel and
your databases. SQL*XL adds a new menu and a new toolbar to
Excel so database access appears to be native. Through comprehensive
dialogs you have interaction with the database.
SQL*XL menu in MS Excel
Explore the database...
SQL*XL provides a simple way to browse through the tables
in your database. This way you can familiarise yourself
with the tables and column details.
Extract data from the database...
Data can be retrieved from the database and put straight
into your Excel spreadsheet. Care is taken to format the
data correctly so you can use the data in e.g. Excel calculcations
and charts without problems. A one click table dump is provided
but the main method for retrieving data is through SQL.
Simply type the select statement and SQL*XL retrieves the
data into Excel.
Data entry & data upload...
A full spreadsheet full of data can be inserted with a few
simple mouse clicks. Simply prepare the data in your spreadsheet
and use the insert multiple rows feature. Feedback is written
next to your data rows to indicate whether the insert was
successful or not.
Change data in the database...
Once data is retrieved into Excel, SQL*XL allows you to
edit the data in the spreadsheet. When the changes are made,
the data can be updated in the database with a few simple
mouse clicks. Optionally SQL*XL will ask you to confirm
each individual change.