Re: data load -ks-

From: Karen <Morgan-Karen_at_home.com>
Date: Tue, 11 Sep 2001 00:15:02 GMT
Message-ID: <aIcn7.738934$K5.79279811@news1.rdc1.nj.home.com>

Use Oracles built-in package called utl_file which allows you to read an write to/from text files. In addition, if needed, you could use this in combination with dynamic sql to write a generic routine which allows the files layout to change over time.

Another option is to use Visual C++ and an odbc connection to accomplish this task.

Karen
Sr. Applications Analyst/Team Leader/DBA

"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 - 19:15:02 CDT