OraFAQ Forum: Server Utilities » Import Excel Data into Oracle

Home » RDBMS Server » Server Utilities » Import Excel Data into Oracle

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

Import Excel Data into Oracle [message #72903]

Fri, 05 December 2003 08:25

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

Report message to a moderator

Re: Import Excel Data into Oracle [message #72906 is a reply to message #72903]

Sat, 06 December 2003 01:31

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

Report message to a moderator

Re: Import Excel Data into Oracle [message #73135 is a reply to message #72903]

Thu, 12 February 2004 08:19

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

Report message to a moderator

Re: Import Excel Data into Oracle [message #73277 is a reply to message #73135]

Mon, 15 March 2004 15:25

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)

Report message to a moderator

Re: Import Excel Data into Oracle [message #73381 is a reply to message #73135]

Tue, 06 April 2004 22:49

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!

Report message to a moderator

Re: Import Excel Data into Oracle [message #73441 is a reply to message #73381]

Fri, 30 April 2004 02:13

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!

Report message to a moderator

Re: Import Excel Data into Oracle [message #73555 is a reply to message #73135]

Thu, 20 May 2004 20:37

sakthi
Messages: 1
Registered: May 2004

Junior Member

Plz give me the details about Importing Excel Data into Oracle Database.

rgs

Report message to a moderator

Re: Import Excel Data into Oracle [message #73668 is a reply to message #72903]

Wed, 16 June 2004 06:14

shihab
Messages: 3
Registered: April 2004

Junior Member

I want to import excel file to oracle.

Report message to a moderator

Re: Import Excel Data into Oracle [message #73727 is a reply to message #73277]

Fri, 25 June 2004 03:18

Yogesh Sharma
Messages: 2
Registered: March 2002

Junior Member

how to import excel data in to oracle

Report message to a moderator

Re: Import Excel Data into Oracle [message #241011 is a reply to message #73277]

Mon, 28 May 2007 03:45

MotiurRahman
Messages: 1
Registered: May 2007
Location: New Delhi

Junior Member

mail2motiur@gmail.com

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

Thnx
Motiur

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 00:02:11 CDT 2024