QueryEditor

QueryEditor is a database analysis tool that allows for easy and efficient creation of database queries, with the ability to customize and export or print data acquired. The program supports various databases through ODBC, including Microsoft SQLServer, Microsoft Excel, Microsoft Access, DBase, Paradox, Sybase SQL Anywhere, MySQL, IBM DB2, Oracle, and more.

System administrators use this tool to provide desired data analysis, with available wizards for linking tables, selecting fields for queries, inserting groups or sorting into a query, opening, editing, or executing saved queries, adding logical column labels and assigning column types, exporting data into Microsoft Excel, CSV-text file, XML file, or HTML document, defining multiple print layouts per query, sending print reports via email, and saving print reports as RTF files (MS-Word), PDF files (Adobe Acrobat), HTML files, GIF graphic files, JPEG graphic files, or WMF and EMF files (Windows Metafile Format).

QEReporter allows other users to utilize print reports without having the ability to edit them. Overall, QueryEditor is a valuable tool for system administrators seeking efficient and customizable database analysis.