Home » RDBMS Server » Server Administration » Import data from excel to oracle table???
Import data from excel to oracle table??? [message #371852] Wed, 13 December 2000 23:32 Go to next message
geetha
Messages: 20
Registered: August 2000
Junior Member
How do I import data from an excel spreadsheet into an Oracle table?
Can anybody elaborate me in detail,

Thanking u in advance
B.Geetha

Report message to a moderator

Re: Import data from excel to oracle table??? [message #371858 is a reply to message #371852] Thu, 14 December 2000 14:13 Go to previous message
usha
Messages: 20
Registered: December 2000
Junior Member
you can do it using sqlloader.
Save the excel spreadsheet as a csv file.

Write a control file (.ctl) explaining the field positions using ',' as the delimiter.

If you are working on unix, just type in sqlldr
which will tell you the parameters for the sqlloader command.

Report message to a moderator

Previous Topic: Conversion of Sybase to Oracle
Next Topic: Conversion to Hexadecimal
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 21:03:18 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.