SQL*XL 3

The tool that simplify all kind of work with databases in MS Excel

XL-Dennis have been using SQL*XL 3 for a longer period. The general impression is that it's a competent, professional and an easy tool to use. Therefore XL-Dennis highly recommends the tool.

What is SQL*XL 3?

SQL*XL 3 is an add-in for MS Excel (97 / 2000 / 2002) that simplifies, in a powerful way, all kinds of work with databases:

• Simplifies all kinds of data collecting and the work with data from external databases in MS Excel.
• A timesaving tool which simplify the work to connect MS Excel to external databases.
• Data can be updated in MS Excel and transferred back to databases in an easy way.
• It is an easy task to create customized reports and settings - Read more »
• Reports can be generated with AutoFilter, which are created automatically.
• Makes it possible and easy to view tables in connected databases.
• Works with all common types of databases that support ADO.

·      Shipped with a help system that is outstanding and easy to use  - Read more ».

·       A professional newsletter for all SQL*XL 3 users - Read more »

• An additional object-library is available, SQL*XL ADO (separate product - Read more »), for developers that makes it possible, in an easy way, to create VBA-solutions which can be fully integrated with SQL*XL 3.

 

After the installation an additional menu is created for SQL*XL 3 in the Worksheet Menu Bar:

 

After the installation we have an easy access to the mainfunctions in SQL*XL3 via the added toolbar:
 

 

In order to establish a connection to an external database we can either use an existent connection or create a new one, which is done in the following form:

SQLXL*3 give us a possibilty to view and check tables in the connected databases, where we first choose which table we want to view:

...and where the result shows as follows:

 

In order to create queries to the connected database following form is used:

 

For additional information about SQL*XL 3: http://www.oraxcel.com/projects/sqlxl/index.htm

For download of LITE-version: http://www.oraxcel.com/downloads/index.htm

For ordering full version of SQL*XL *3 : http://www.oraxcel.com/order/order.html

 

SQL*XL 3 is a trademark that belongs to  LIT Software and all pictures above belongs to LIT Software.

© 2003 All rights reserved LIT Software