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

• 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!

• 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.

• 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

• IBM have developed their own add-in for MS Excel, IBM Office Connect, but this is only avaliable via the Toolbox subscription and the subscription cost 10 times more then SQL Tester!
  
  Following articles about using ADO with the DB2 OLE DB Provider are recommended to take part of:
  
  DB 7.2 and Visual Basic 6.0 - Bound and Unbound Forms
  
  Getting Started with DB2 V8 and ADO using Visual Basic 6
  
  DB2 Development Add-Ins for Visual Studio 6.0 - The Next-Generation AD Tooling
   
• Following  providers should be used:
  
   -  For DB2 it is recommended to use the IBM OLE DB Provider for DB2.
  
   -  For Informix use the OLE DB Provider for Informix or the ODBC-driver Informix.
  
      
• If You are running AS/400 DB2 you may use the Microsoft OLE DB Provider for AS/400 and VSAM. The provider is bundled with the Microsoft Host Integration Server client software.

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.

• 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 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.