Home » RDBMS Server » Server Administration » loading excel data into oracle database
loading excel data into oracle database [message #371966] Wed, 27 December 2000 18:12 Go to next message
Sukumar Jana
Messages: 2
Registered: December 2000
Junior Member
Hi,
I'm wondering how to save microsoft excel data into oracle database. could anyone help with some idea?
Thanks

Report message to a moderator

Re: loading excel data into oracle database [message #371967 is a reply to message #371966] Wed, 27 December 2000 19:12 Go to previous messageGo to next message
bc
Messages: 4
Registered: December 2000
Junior Member
Export the data from excel sheet to a file in csv format, then use SQL loader to load data into Oracle Table

Report message to a moderator

Re: loading excel data into oracle database [message #372012 is a reply to message #371966] Wed, 03 January 2001 13:15 Go to previous messageGo to next message
Ravi Prasad
Messages: 9
Registered: January 2001
Junior Member
write a control file and use SQL*Loader to load the data into oracle......
no need to convert into CSV format

bye
Ravi

Report message to a moderator

Re: loading excel data into oracle database [message #374757 is a reply to message #371966] Thu, 28 June 2001 19:38 Go to previous message
JOHN
Messages: 182
Registered: April 1998
Senior Member
Hello
Assuming you do not have access to the Oracle table(s), you could automate your process by using a shareware program available from EZ_2_Use_Software. It can be downloaded from

http://www.geocities.com/ez_2_use_software/index.html

Report message to a moderator

Previous Topic: Is it possible to get SQL*Plus to recognise windows shortcuts
Next Topic: Is it possible
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 06 07:55:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.