Re: data load -ks-

In addition to what Karen said.... you can ...

1. Use MS Access to do this. Probably not good for your case.
2. Use any programming language like perl, python, java, C or even PL/SQL... to parse your csv file into insert statements. Will work good if data to be loaded is less
3. Use any programming language (perl being my favorite) to dynamically generate a control file for the csv file and then call sqlldr to load the data from perl itself.
4. Just for info: In 9i you can create external tables to do this
5. Go to www.quest.com ... I think they have a tool which does that. Its either Data Manager or DataFactory

Anurag

"kshathrya" <kshathrya_at_hotmail.com> wrote in message news:tppobcgqfjd9b_at_corp.supernews.com...
> Hi,
> Is there a way we can load data into oracle using some wizards or
> something, from excel or flat files, without having to create conrol
files.
> In the sense, my flatfiles first column will be the column name of that
> particular table, whichj has to be generated in runtime. We have utilities
> in sqlserver, but am wondering whether there is any way or tool that can
> help.
>
> thanks
> ks
>
>
Received on Mon Sep 10 2001 - 20:15:48 CDT