SQL Tester
The tool for retrieving data from databases and putting it into MS Excel
Important:
The present version does not support Excel 2007
A new version will be available during the 2nd quarter 2008
which will work with Excel 2007
All present customers will get a free update.
What the SQL Tester is
The SQL
Tester is an interactive Query Tool (add-in) for retrieving data and displaying it on the
screen in an ad hoc basis from almost all kinds of databases. The output can be
placed in worksheets and added to workbooks VBA-projects.
| It also allows you to: |
- Copy
the displayed data into a worksheet including connection-string
and query-string
|
- Create dynamic queries where the data can
be updated on a regular basis.
|
-
Insert a complete VBA-procedure which is based on the query and the
database-connection.
|
- Easily create queries by selecting keywords, names of tables and columns
from user-friendly forms.
|
- Create, test and export the queries to
the clipboard or to textfiles.
|
- Import queries from textfiles and have
them executed.
|
- Work with disconnected records.
|
- Get more accurate and higher quality of
the retrieved data compared to MS Query.
|
- An extensive helpfile is available.
|
- The best part is that You are not bound
to the databases tools & windows!
|
Requirements
In order to
use the SQL Tester you need to have the following software and versions
installed:
- Microsoft Windows 2000 or above
|
- Microsoft Excel 2000 or above
|
- MDAC 2.5 (Microsoft Data Access Components) or above.
It is the Active Data Objects (ADO) Library that is necessary.
|
As a user you
must, at least, have a basic knowledge about the Structured Query Language (SQL)
itself,
and also have some basic experience of working with databases.
Price
|
$33 for a single license which
include future versions of the add-in.
(VAT may be applicable to the price)
If you are interested in a bulk licence purchase discount, please contact Sales |
|
|
For swedish customers other methods of payment can be arranged.
Please
send an e-mail to
Sales. |
|
|
30 Day Money Back Guarantee |
|
SQL Tester has successfully
been tested with the following databases:
|
- Textfiles
- Dbase version V and version VI
- Domino / Lotus Notes databases 5.x (Require
NotesSQL ODBC Driver)
- Ingres (All versions)
- Microsoft Access version 97, 2000, 2002
and 2003 (extensively)
- Microsoft Excel version 97, 2000, 2002
and 2003 (extensively)
- Microsoft SQL 6.5, 7.0 and Server 2000
SP-3 (extensively)
- Microsoft Visual FoxPro Database
- Mimer SQL 9 (Windows version)
- MySQL version 3.23.57 and 4.0.14 (For
best performance use 4.0 or above.)
- MaxDB
- Oracle version 8i and 9i (Oracle´s OLE DB
Provider highly recommended)
- Pervasive .SQL V8
- SQL Anywhere Studio Base
- SQLBase 8.5
| SQL Tester has not been
tested with the following databases from IBM but it is possible to
retrieve data from them by using the appropiated providers. |
SQL Tester have not been explicit tested with SCALA or SAP but both system
use common databases such as MS SQL Server and Oracle. Therefore it is
possible to retrieve data via the specific OLE DB Provider for each
databasetype.
|
|
Technical Support & Consultancy :
|
Please report any
technical problems You encounter with SQL Tester to
Support
You should include:
- Operating System used (Windows 2000 etc including any Service Pack (SP)-number
)
- MDAC version
- MS Excel Version
- Language version of both MS Windows and MS Excel (English, Swedish etc)
- SQL Tester version and build-number (see the About-screen)
- Any message in the Statusbar when the problem occurred
- Error Message
- Any output from SQL Tester
- As much details of the problem as possible
- If the problem(s) refer to installation then attach the file
Vinstall.text which is located in the same folder as the SQL Tester's
files.
Please also see FAQ for SQL Tester.
If the problems refer to SQL Tester a new updated version will be made
available for download as soon as possible and an e-mail will be sent to all
registered users.
Please note that the free support does not include:
- Questions and problems related to how to
- create and maintain SQL-statements
- manually set up database-connections or
- manually edit and update generated VBA-code.
- Using SQL Tester on non-supported platforms of MS Windows or versions
of MS Excel.
- Questions regarding MS Excel.
You are welcome to request additional chargeable support and consultancy
services from XL-Dennis. Send a brief outline of the work you would like
done to Consult and I will contact you to work out the details. |
The menu:
Nearly all forms can be displayed at the same time on the screen,
ie they are set to be modeless. To see SQL Tester in full action click on the
thumbnail-picture below:
The picture below shows the main screen of SQL Tester.
The picture below shows the screen for tables:
Next picture shows the screen for columns for the selected table
in the screen above:
The following picture shows the screen for keywords that can be
inserted in the query-field when creating queries:
The picture below shows the main screen for settings:
The helpfile:
Special thanks go to Mr Richie Sills, my good friend
in the UK, for proofreading.
