OraFAQ Forum: Server Utilities » Importing data from .csv file

Home » RDBMS Server » Server Utilities » Importing data from .csv file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Importing data from .csv file [message #138072]

Mon, 19 September 2005 17:08

hubstack
Messages: 12
Registered: August 2005

Junior Member

I need to import data into a SQL table. How do I do that? The source dataset is a comma-delimited file (create.csv). I'm using SQL Navigator.

Thanks.

Report message to a moderator

Re: Importing data from .csv file [message #138081 is a reply to message #138072]

Mon, 19 September 2005 19:35

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Use the SQL*Loader utility. For details, see the SQL*Loader FAQ on this site

Best regards.

Frank

Report message to a moderator

Re: Importing data from .csv file [message #139399 is a reply to message #138072]

Tue, 27 September 2005 17:21

RadhaP
Messages: 1
Registered: March 2005

Junior Member

Open the .csv in MS Acess and export it as a .txt fila and use SQLLDR to import data into SQL table.
-Rad.

Report message to a moderator

Previous Topic:	problems in IMPORT
Next Topic:	how to take export users

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 09 01:46:23 CST 2024