|
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!
SQL Tester
System 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.
|
|
