SQL Tester for retrieving data from databases, putting into Excel

Make BestShareware.net your home page

Add BestShareware.net to your favorites

Homepage

MAC Software | Linux Software | Pocket PC | iPod Software | Zune Software

Software Directories

Internet
Graphics
PC Tools
Applications
Development
DVD & Video
MP3 & Audio
Computer Games
Security & AntiVirus

Applications

Business Finance
Personal Finance
Database Tools
Personal Managers
Business Managers
Inventory Management
Project Managers
Accounting Tools
Home & Education
Unit Conversion
Word Processing

SQL Tester

The SQL Tester is an interactive Query Tool (MS Excel add-in) for retrieving data from databases 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.
SQL Tester 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 and windows!

Download From Now 3.16 MB

Buy Now $33.00 USD

Software Information		System Requirements
Version	1.10	Windows 2000 or above Memory: 128 Mb 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
File Size:	3.16 MB
License:	Free to try, $33.00 to buy
Screenshot:	View main screen of SQL Tester
Rating :

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)
MaxDB
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
SQL Anywhere Studio Base
SQLBase 8.5