Re: ASCII data import

In article <3178C383.3C63_at_xs4all.nl> roald_at_xs4all.nl "R.A. van Geleuken" writes:

> Teresa Narvaez wrote:
> >
> > Hi, I have a question on how to import an ASCII comma delimited file into
> > oracle. What tool should I use to accomplish this?
> >
> > Thanks for any help,
> > -Teresa
>
> You could use SQL*Loader, but if the amount of data is not too large
> and you have some experience with vi, why not simply make an SQL-script
> with insert-statements. This works fine for me.
>
> Roald.
> --
>
> +-------------------------------------------------------+
> | R.A. van Geleuken roald_at_xs4all.nl |

 +-------------------------------------------------------+


> | There's no such thing as impossibility, only          |


> | extremely low chance                                  |

> +-------------------------------------------------------+

        As it happens I created a program, some time ago, that converted commer seperated files into oracle insert statements.

        If you need I will see if I can dig out the program or code. It is built around a specific file format so it will probably need changing to work with your files. email me if you want.

steve
steve_at_chigtow.demon.co.uk  

-- 
STEPHEN  LEONARD  ROBERTS