Convert Query Result into *.CSV, *.TXT, *.XLS or Fill Into Crystal Report

Database To Text File Utility

Database To Text File Utility “Database to text file” is a small utility that encourage anyone who need to export the query results into a file. Now, it supports the SQL Server and ODBC connections. Besides export query results into text file, it support to print your query results out with Crystal Report.

Features

Export query’s result into text file,
Export query’s result into Microsoft Excel,
Print Query Result using Crystal Report,
Export or import query setting from developer to end user or vice versa,
Easy to maintain the query,
Result can be ordered,
Flexible filter feature,
Support SQL Server and ODBC connection,
Preview Query Result,
Generating fields definition only (TTX) or XML Schema to support reporting in Crystal Report,
Shortcuts to access menu,
Developed using C# .Net,
Long live innovation features in the future,
Attached with samples using ODBC for best practice,
FREEWARE : Free to use, free to distribute

How To Use ?

To using this utility, you need to do an installment first. If your computer has not been installed with .Net Framework, you need to installed it first (click here to download).
This utility can be divided into 2 kind of purpose :

Client Using
Developer Using

This utility can be distributed to end user who did not knew about queries. After installation process completed, the utility will perform as “client using” with a query sample displayed. If you need to modify the query, you must switch the utility into the developer state.

How to switch to developer state ?

In order to run at developer state, you need to run from “Run” window, and type this command : "...\program files\db2text\dbtottext.exe" WilTech-Center. Now, you can add your new query, modify the existing query or delete your query.

How to Export the Query’s Setting ?

To export your query setting, you simply click the menu : File > Export Configuration’s Setting With this features, you can get all query setting, including the column setting and connection settings.

How to Import the Query’s Setting ?

To import your query setting, you simply click the menu : File > Import Configuration’s Setting With this features, you can distribute the query to the end user including the columns settings. After imported the setting, you need to close the utility and re-open it again.

How to Print your Query’s Result to Crystal Report?

You must already have a Crystal Report file (*.rpt) that has been design followed the query. If you want to design and need to use field definition from your query, you can generate them by click on File>Generate Field Definition (Ctrl+D), you can chose the file type in order to generate to TTX or XML’s File. After designed your report, from Database To Text Utility, you can print the query result by click on File>Print As Report (Ctrl+P).

History :

11 July 2008 (Version : 1.2.1)

Some bugs fixed

03 May 2008 (Version : 1.2.0)

Re-launching at www.wiltech-center.com and submit in www.codeproject.com
Auto sign column order

09 April 2008 (Version : 1.1.0)

Support ODBC connection,
Preview Query Result,
Generating fields definition only (TTX) or XML Schema to support reporting in Crystal Report,
Print Query Result using Crystal Report,
Add shortcut to access menu,
Bugs fixed in filter condition

17 April 2008 (Version : 1.1.1)