Re: Is it possible to export a table to a txt-file??

Chyfo works VERY good!!
Thanks!!

Øyvind.

"Dmitry" <support_at_ispirer.com> wrote in message news:9f2cjj$1rvu6$1_at_ID-75577.news.dfncis.de...
> Hi,
>
> Try to use Chyfo (http://www.ispirer.com/products/). This tool can easily
> export data to different text formats including fixed length.
> It is easy to use tool and takes 40K on disk.
>
> Best regards, Dmitry
>
> "?yvind Skjold" <o-skjold_at_online.no> wrote in message
> news:RHNQ6.2930$vu4.287476_at_news3.oke.nextra.no...
> > It almost works as I want...
> > But I don't get a doc with columns with constant fieldwith..
> > I get this:
> >
> > 78 1 2 26.4.01 00:00:00 0
> > 0
> > 0
> > 0
> > 2 -46775
> > 26.4.01 00:00:00 K1
> > J0
> > 0
> > 0
> >
> >
> > -8048,05
> > KTAN TAN 0
> > 0
> > 0
> > 0
> >
> > .
> > .
> > .
> >
> >
> > But I want:
> >
> > 78 1 2 26.4.01 00:00:00 0 0 0 0 2 -46775 26.4.01 00:00:00 K1
> >
> > 78 1 1 26.4.01 00:00:00 0 0 0 0 1 46775 17.5.01 00:00:00 A1
> >
> > 78 1 3 26.4.01 00:00:00 0 0 0 0 3 41425 26.4.01 00:00:00 A1
> >
> > 78 1 5 2.5.01 00:00:00 0 0 0 0 5 74253 2.5.01 00:00:00 A1
> >
> > Any id?as??
> >
> > ?yvind.
> >
> >
> > "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> > news:th4lc6apqi0hfe_at_beta-news.demon.nl...
> > > Corrected link is
> > > http://asktom.oracle.com/~tkyte/flat/index.html
> > >
> > > Your code is incorrect.
> > > You should fire up sqlplus and issue
> > > set heading off feedback off pagesize 0 newpage 0
> > > spool <any filename>
> > > select ...
> > > from ...
> > > etc.
> > >
> > > Hth,
> > >
> > > Sybrand Bakker, Oracle DBA
> > > The usual adminition to read manuals applies.
> > >
> > >
> > > "?yvind Skjold" <o-skjold_at_online.no> wrote in message
> > > news:ItrQ6.2051$lM3.44540_at_news1.oke.nextra.no...
> > > > Ok,
> > > >
> > > > thanks!!
> > > >
> > > > But how do I write a sql-select to a file?
> > > > Something like this:
> > > >
> > > > <SQL> select A,B,C.... from TABLE > file
> > > >
> > > > By the way, the link to Tom Kyte's website didn't work..
> > > >
> > > > ?yvind
> > > >
> > > >
> > > > "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> > > > news:th4g3of7qb0pd3_at_beta-news.demon.nl...
> > > > >
> > > > > "?yvind Skjold" <o-skjold_at_online.no> wrote in message
> > > > > news:dIqQ6.2031$lM3.44341_at_news1.oke.nextra.no...
> > > > > > Hey,
> > > > > >
> > > > > > I've a problem saving tables through ODBC - ACCESS. The files
 get
 so
> > > > > > incredible huge..
> > > > > > So I'm wondering if it's possible to export directly to a
 txt-compatible
> > > > > > file..( with predefined fieldlength )?? Or isn't it possible??
> > > > > >
> > > > > > I'm pretty new i the game, so you have excuse me if it's a silly
 question
> > > > > > :-)
> > > > > >
> > > > > > ?yvind.
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > > You have several options
> > > > > 1 download the flat file utility from Tom Kyte's website
> > > > > (http:///osi.oracle.com/~tkyte)
> > > > > 2 Use Toad for this purpose if you already have it
> > > > > 3 Write your own select
> > > > >
> > > > > I do not however believe the size of the file is really going to
 change.
> > > > >
> > > > > Hth,
> > > > >
> > > > > Sybrand Bakker, Oracle DBA
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Received on Sat Jul 21 2001 - 23:48:08 CEST