Home » RDBMS Server » Server Utilities » Import Excel Data into Oracle
Import Excel Data into Oracle [message #72903] Fri, 05 December 2003 08:25 Go to next message
syed
Messages: 8
Registered: October 1999
Junior Member
Hi all,
Can any one help me regarding the matter of Importing Excel sheet data into Oracle by using SQL*Loader Utility. I have to pick data from Excel File and slam it to Oracle Database within two different table same time. Also I have to perform validation and in the case of wrong data I have to sent email back to client.
Any help will be appreciated.
Thanks
Syed
Re: Import Excel Data into Oracle [message #72906 is a reply to message #72903] Sat, 06 December 2003 01:31 Go to previous messageGo to next message
Sajid Fahim
Messages: 4
Registered: December 2003
Junior Member
make text file of your excel data and than
use text_io built-in packages to insert your tables
and validate the data
Re: Import Excel Data into Oracle [message #73135 is a reply to message #72903] Thu, 12 February 2004 08:19 Go to previous messageGo to next message
essam
Messages: 1
Registered: February 2004
Junior Member
hi i want to know how i can import exel data to oracle without use odbc driver please
Re: Import Excel Data into Oracle [message #73277 is a reply to message #73135] Mon, 15 March 2004 15:25 Go to previous messageGo to next message
mui tjhai
Messages: 1
Registered: March 2004
Junior Member
How can I import an Excel file to Oracle table using Developer 2000 or an SQL command?
(Both Excel file and Oracle table have identical column)
Re: Import Excel Data into Oracle [message #73381 is a reply to message #73135] Tue, 06 April 2004 22:49 Go to previous messageGo to next message
july
Messages: 1
Registered: April 2004
Junior Member
Hi! I want to know how i can import exel data to oracle without use odbc driver please!
Thank you!
Re: Import Excel Data into Oracle [message #73441 is a reply to message #73381] Fri, 30 April 2004 02:13 Go to previous messageGo to next message
marco
Messages: 46
Registered: March 2001
Member
Hi! I want to know how i can import exel data to oracle without use odbc driver please!
Thank you!
Re: Import Excel Data into Oracle [message #73555 is a reply to message #73135] Thu, 20 May 2004 20:37 Go to previous messageGo to next message
sakthi
Messages: 1
Registered: May 2004
Junior Member
Plz give me the details about Importing Excel Data into Oracle Database.

rgs
Re: Import Excel Data into Oracle [message #73668 is a reply to message #72903] Wed, 16 June 2004 06:14 Go to previous messageGo to next message
shihab
Messages: 3
Registered: April 2004
Junior Member
I want to import excel file to oracle.
Re: Import Excel Data into Oracle [message #73727 is a reply to message #73277] Fri, 25 June 2004 03:18 Go to previous messageGo to next message
Yogesh Sharma
Messages: 2
Registered: March 2002
Junior Member
how to import excel data in to oracle
Re: Import Excel Data into Oracle [message #241011 is a reply to message #73277] Mon, 28 May 2007 03:45 Go to previous message
MotiurRahman
Messages: 1
Registered: May 2007
Location: New Delhi
Junior Member

Hi,
i m also facing the same.If u have any solution pls provide me also.

Thnx
Motiur
Previous Topic: Export from Oracle 9.2.0.3 : EXP-00056: ORACLE error 4068 encountered
Next Topic: SQL*LOADER
Goto Forum:
  


Current Time: Fri Dec 09 21:07:46 CST 2016

Total time taken to generate the page: 0.06427 seconds