SQL Tester
The tool for retrieving data from databases and putting it into MS Excel

 

 

News

Version 1.2 is now available which supports Excel 2000 to 2007 on Windows Vista or Windows XP. If you have a valid license of SQL Tester then please e-mail to support@xldennis.com in order to get the updated version.

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

Note

 Read RegNow (my order processor) Privacy Statement

 

SQL Tester has successfully been tested with the following databases:
 
  • Textfiles
     
  • Dbase version V and version VI
     
  • Domino / Lotus Notes databases 8.x (Require NotesSQL ODBC Driver)
     
  • Ingres (All versions)
     
  • Microsoft Access version 97- 2007 (extensively)
     
  • Microsoft SQL Server 6.5, 7.0, 2000, 2005 and 2008 (extensively)
     
  • Microsoft Visual FoxPro Database
     
  • Mimer SQL 9 (Windows version)
     
  • MySQL version 4-5 (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.
 

 

 

The screen shot below shows the main screen of SQL Tester.
 

 

The following screen shot shows the screen for tables:

 

Next screen shot shows the screen for columns for the selected table in the screen above:

 

The following screen shot shows the screen for keywords that can be inserted in the query-field when creating queries:


The screen shot below shows the main screen for settings:


 

The help file: