Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Importing CSV file to Oracle

Re: Importing CSV file to Oracle

From: bhogak <bhogak_at_yahoo.com>
Date: Sat, 12 May 2001 08:59:28 -0500
Message-ID: <9djfs6$j4u$1@bob.news.rcn.net>

You probably have to use DBMS_UTILITY.COMMA_TO_TABLE to read the flat file into a PL/SQL table and then create a table using Dynamic SQL. -bhogak
Tim Mavers <webview_at_hotmail.com> wrote in message news:3afc286e$0$16451$45beb828_at_newscene.com...
> I am trying to figure out how to import a CSV file to a table in Oracle
 8i.
>
> I know I can use sqlldr, but this requires control file that describes the
> data to import. The problem I have is the format of this CSV is dynamic.
> Actually it's pretty static, except that the number of columns can change.
>
> Is there a way I can just import a CSV file and have Oracle create the
 table
> (I supply the name) for me?
>
> In MS SQL Server, I used DTS which was pretty straightforward. Is there
> something equivalent in Oracle?
>
>
Received on Sat May 12 2001 - 08:59:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US