OraFAQ Forum: SQL & PL/SQL » Insert data in Oracle table from text file or Excel file

Home » SQL & PL/SQL » SQL & PL/SQL » Insert data in Oracle table from text file or Excel file

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

Insert data in Oracle table from text file or Excel file [message #416486]

Mon, 03 August 2009 01:51

onkar07
Messages: 7
Registered: August 2009
Location: Navi Mumbai

Junior Member

hi all

anybody knows how to insert data in orale table from Text File Or Excel File.

pls Help.

Regards
Onkar

[Updated on: Mon, 03 August 2009 02:37] by Moderator

Report message to a moderator

Re: Insert data in Oracle table from text file or Excel file [message #416499 is a reply to message #416486]

Mon, 03 August 2009 02:18

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

There are ways, and I guess that most of them have been discussed on this Forum. Search for SQL*Loader, CSV files, external tables, OLE (and perhaps something else, which might be specified by other forum members).

Report message to a moderator

Re: Insert data in Oracle table from text file or Excel file [message #416529 is a reply to message #416486]

Mon, 03 August 2009 04:50

furqanhussain
Messages: 6
Registered: June 2009
Location: Karachi

Junior Member

You can easily move data from text file to oracle database,but first you need to Pl/Sql Developer and then go to tool menu on click to text Importer.to this option you will have to define column & as well as data type.

Rgd
Furqan Hussain

Report message to a moderator

Re: Insert data in Oracle table from text file or Excel file [message #416829 is a reply to message #416486]

Tue, 04 August 2009 09:32

tapaskmanna
Messages: 98
Registered: January 2007
Location: Cyprus,Nicosia

Member

Hi,

UTL_FILE Package can also be explored to upload the data from file.

Report message to a moderator

Previous Topic:	error adding column
Next Topic:	TO_DATE Function (merged 2) 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 28 12:30:10 CST 2026