THE Ultimate  Excel Portal     [ Popular | New | Editor's Picks | Top Rated ]
Home >> Previous Page >> SQL Tester (link details)
Main Categories
Excel Add-ins
Excel Help
Excel Password Recovery
Excel Templates
Excel Tips & Tricks
Excel Tutorials
Excel VBA
Free Excel Add Ins
Spreadsheet Research
Create Excel Dashboard Reports with Plug-N-Play Reports
Newest Links
Vertex42 Money Manager
Kaizen Excel Templates
Learn Excel VBA Easily
Employee Payroll Spreadsheet
Viral Growth Forecaster
Excel Training Guides
The Formulator
Financial Modeling Training Program
Customer Invoicing Template
Personal Debt Analyser

SQL Tester

Domain: www.XLDennis.com/SQLTester.htm
Categories: Databases and Excel


The SQL Tester is an interactive Query Tool (add-in) for retrieving data and displaying it on the screen from almost any kind of database. The output can be placed in worksheets and added to workbook VBA-projects.

Rating: 5.00 (1 votes)
Added: 08-02-2004 - Updated: 01-11-2007 - Comments: 0 - Hits month/total: 1/1985
Report error

Version (if applicable): 2000/2002(XP)/2003
Rate This Link
Extremely Satisfied
Satisfied
Neutral
Confused
Disappointed


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


Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation. This site is in no way associated with Microsoft.