SQL Tester - SQL Tester 1.1 by XL-Dennis

SQL Tester is the perfect tool for retrieving data from databases and putting it into MS Excel.

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 retrieved data compared to MS Query.

An extensive helpfile is available, and the best part is that You are not bound to the databases tools & windows!

SQL Tester has successfully been tested with the following databases:

Download Now for $33.00 : Visit XL-Dennis for More Information

Textfiles
Dbase version V and version VI
Domino / Lotus Notes databases 5.x (Require NotesSQL ODBC Driver)
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.)
Oracle version 8i and 9i (Oracle�s OLE DB Provider highly recommended)
Pervasive .SQL V8
SAP DB 7.4.03.30 (Free Open Source Database from SAP)
SQL Anywhere Studio Base
SQLBase 8.5

Works on Windows 2000, NT, and XP

Download Now for $33.00 : Visit XL-Dennis for More Information