Query Assistant - connect to databases and execute queries.

[Peter Swinkels]

What is the Query Assistant?
A tool intended to help make connecting to databases, executing queries, and export their results.

What can it do?
1. Connect to database using Microsoft ADO as specified by a connection string in a settings file.
2. If configured as such, request the user for a password and/or user name and fill in the respective place holders in the connection string.
3. Load a query specified as a command line argument or as selected by the user from inside the program's interface.
4. Display input boxes for controlled input as specified by input place holders inside, if present, a query.
5. If configured as such, execute a series of queries in a batch.
6. Export a query's results to a text file or Microsoft Excel spreadsheet, when required.
7. Attach the file with the query's results to an e-mail, fill in the sender, recipient, subject, and body as specified in a settings file and then send it.
8. Insert data such the date, time, an operating system environment variable's value, an input box's value into a query or e-mail.

It also comes with an extensive help file describing:
1. What the program does.
2. The supported settings.
3. The supported command line arguments.
4. The supported file types for exported query results.
5. How to define input place holders in a query.
6. How to insert data into an e-mail or query.
7. How to create a tiny example database, query and, settings file.
8. How to view a description for each control inside the interface.

An image showing the program's main interface, Microsoft Excel and Outlook:
Attachment 117155

Contents for Qa.v1.65.zip:
.\Qa.v1.65\Interface.frm
.\Qa.v1.65\Interface.frx
.\Qa.v1.65\Logon.frm
.\Qa.v1.65\Logon.frx
.\Qa.v1.65\Qa.bas
.\Qa.v1.65\Qa.vbp
.\Qa.v1.65\Documents\Qa_Help.docx

Notes:
-Also included is the original Dutch language version. Its file formats are slightly different for reasons of backwards compatibility and because of language differences.
-Before the program can be used, a settings file, containing at least a connection string under the appropriate header ("[Connection]" or "[Verbinding]" (Dutch)). The program looks for a file called "Qa.ini" by default unless otherwise specified in a command line argument. The setting file's extension must always be ".ini".

-The executables can be downloaded here: https://drive.google.com/open?id=0Bw...zlZa0JJRW05eFk

BTW:
See my latest post for bug fixes and sample files.