Home » RDBMS Server » Server Utilities » importing data from excel to oracle tabel???
importing data from excel to oracle tabel??? [message #368402] Thu, 14 December 2000 05:35 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 explain me how to do this in detail.....

Thanking u in advance...
B.Geetha
Re: importing data from excel to oracle tabel??? [message #368405 is a reply to message #368402] Thu, 14 December 2000 11:34 Go to previous messageGo to next message
Neeraja
Messages: 8
Registered: November 2000
Junior Member
try using data junction
Re: importing data from excel to oracle tabel??? [message #368406 is a reply to message #368402] Thu, 14 December 2000 13:23 Go to previous message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi
There are many ways to do it....
the easiest one is.....
Use MS-ACCESS to first import the excel into access table. And using odbc export it to oracle table............

Or use oracle utility sqlldr....
goto
http:\technet.oracle.com and search for 'sqlldr'
you have detailed docs over there.......
Previous Topic: Re: Importing 7.3.3 dmp (Enterprise) in 8.0.4 (Personal)
Next Topic: formating sql output
Goto Forum:
  


Current Time: Fri Mar 29 10:39:02 CDT 2024