OraFAQ Forum: Server Administration » Convert Excel files into Oracle

Home » RDBMS Server » Server Administration » Convert Excel files into Oracle

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

Convert Excel files into Oracle [message #173887]

Thu, 25 May 2006 02:04

Mitesh Shah
Messages: 24
Registered: August 2004

Junior Member

I am having problem converting excel files into oracle 8i

Please help and tell me the detail procedure for convering excels files into Oracle 8i Tables

Thanks,

Report message to a moderator

Re: Convert Excel files into Oracle [message #173889 is a reply to message #173887]

Thu, 25 May 2006 02:18

viplove
Messages: 9
Registered: May 2006

Junior Member

hi mitesh,

first of all save ur excel sheet as either tab delimited or .csv file.

then create a table in oracle, create a .ctl file, use sqlloader

on the command line write sqlldr username/pass control='urctlfile'

this is all that is required

viplove

Report message to a moderator

Re: Convert Excel files into Oracle [message #173952 is a reply to message #173889]

Thu, 25 May 2006 06:31

Mitesh Shah
Messages: 24
Registered: August 2004

Junior Member

Thanks VIPLOVE for your valuable reply,

Please help me on how we can create .ctl file in ORACLE 8i. I Can not find the SQL Loader in ORACLE 8i. Please tell me exactly where it is.

Your prompt reply is highly appriciable.

Thanks a lot again

Mitesh Shah

Report message to a moderator

Re: Convert Excel files into Oracle [message #174716 is a reply to message #173952]

Tue, 30 May 2006 06:54

Mitesh Shah
Messages: 24
Registered: August 2004

Junior Member

Thanks a lot VIPLOVE

I have got how to create .ctl file and how to import excel data into oracle tables.

Thanks a lot again.

If you can help me or give me the Structure(format) of ".CTL" File the it would be helpful to me.

Mitesh Shah

Report message to a moderator

Re: Convert Excel files into Oracle [message #174838 is a reply to message #173887]

Tue, 30 May 2006 14:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Go to http://tahiti.oracle.com & RTFM called "Utilities Manual".

Report message to a moderator

Previous Topic:	error while creating Dictionary managed Tablespace
Next Topic:	RAID5 and Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:43:32 CDT 2024