OraFAQ Forum: Server Utilities » import excel csv file into database

Home » RDBMS Server » Server Utilities » import excel csv file into database (oracle 10g)

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

import excel csv file into database [message #393505]

Mon, 23 March 2009 02:22

rajasekhar857
Messages: 500
Registered: December 2008

Senior Member

Hi,
i want to import .csv file to a database using sql*loader.how to perform it.My table is like this

CREATE TABLE EMRRaceLkup(
	RACE_ID NUMBER (20) NOT NULL,
	UNIQUE_IDENTIFIER NUMBER (20),
	HIERARCHICAL_CODE VARCHAR2 (20),
        CONCEPT VARCHAR2 (50),
        STATUS NUMBER (10)
) 
/

Now i want columns 2,3,4 as per excel sheet in to the data base. can any one help me how to do this

Attachment: CDC Race and Ethnicity Code Set Version 1(1).0.csv
(Size: 30.05KB, Downloaded 1567 times)

Report message to a moderator

Re: import excel csv file into database [message #393512 is a reply to message #393505]

Mon, 23 March 2009 03:08

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The documentation is still at the same place.

Regards
Michel

Report message to a moderator

Re: import excel csv file into database [message #394157 is a reply to message #393505]

Wed, 25 March 2009 20:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Alternatively, use EXTERNAL TABLES
http://tahiti.oracle.com

Report message to a moderator

Previous Topic:	Exclude tables in my schema import
Next Topic:	Load data from thousands of CSV files into one table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 19:20:59 CST 2024