Need export data to a text file?
From: <dmalto_at_mail.ru>
Date: Fri, 05 Jan 2001 15:49:29 GMT
Message-ID: <934qe5$lkb$1_at_nnrp1.deja.com>
Date: Fri, 05 Jan 2001 15:49:29 GMT
Message-ID: <934qe5$lkb$1_at_nnrp1.deja.com>
You can take a tool that exports data to a text file (CSV,TAB,fixed) at: http://www.simtel.net/pub/simtelnet/win95/database/chyfo171.zip (version 1.7.1, 30k size, platform Win9x/NT/2000)
You can export data from almost all databases (which has ODBC driver).
Its features:
- comma delimited (CSV), tab delimited, fixed length formats;
- you can provide any SQL SELECT statement;
- list of columns to be excluded from converting;
- start row and count of rows;
- generates native table creation scripts for IBM DB2, Oracle and MS SQL Server;
- generates import scripts for IBM DB2 (DB2 IMPORT and DB2 LOAD command), Oracle (SQL Loader control file), MS SQL Server (BCP utility)
Support: dmalto_at_mail.ru
Best regards, Dmitry
Sent via Deja.com
http://www.deja.com/
Received on Fri Jan 05 2001 - 16:49:29 CET