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