You need text exports from ODBC
Export table data through an ODBC data source into CSV, tab-delimited, or fixed-width files.
Table2Text
Free command-line utility for exporting ODBC table data into CSV, tab-delimited, or fixed-width text files.
Table2Text is freeware for technical users who need a small command-line tool to export database tables through ODBC into text files. It is useful for scripts, support checks, simple data hand-offs, and repeatable table extracts where a full ETL project would be more than the job needs.
Choose Table2Text If You Need A Small Table Export Utility
You need command-line execution
Run exports from batch files, scheduled scripts, support routines, or manual command prompts.
You need freeware for small jobs
Use it for personal or business work when the requirement is a focused table-to-text export.
What Table2Text Handles
ODBC table exports
Connect through an ODBC data source and export records from a selected table.
CSV files
Create comma-separated text files for checks, transfers, imports, and simple reporting.
Tab-delimited files
Export rows into tab-separated files when downstream tools expect tab-delimited input.
Fixed-width files
Create fixed-width text output for older systems and structured text exchange.
Fast extracts
Export thousands of records per second for simple table extracts.
Scripted runs
Use command-line parameters so repeat exports can be kept in scripts.
Usage Example
Pass the ODBC data source, credentials, table name, and output file path as command-line parameters.
table2text.exe DSN=odbcdsn;USER=username;PASSWORD=password;TABLE=table_name;FILE=c:\exports\table.csvCommon Table2Text Workflows
- Export a database table to CSV for a support request or data check.
- Run the same extract from a batch file instead of opening a desktop tool.
- Create tab-delimited text files for another application or import process.
- Generate fixed-width files for older systems that still expect strict column positions.
- Use ODBC so the same utility can work with different database drivers.
Supported Export Work
Table2Text is built for table-to-text export through ODBC. The exact databases available depend on the ODBC drivers installed on the machine running the utility.
ODBC CSV TAB Fixed-width Command line Batch scripts Table exports
Download Table2Text
Download the freeware utility directly. No registration is required.