Home » Developer & Programmer » Forms » Converting Data from Excel to Database of Oracle
Converting Data from Excel to Database of Oracle [message #132690] Mon, 15 August 2005 13:27 Go to next message
shahzaib198
Messages: 6
Registered: August 2005
Junior Member
can any one tell how to Convert Data from Excel to Database of Oracle

i know there are convertors

but i want another methods mean in steps

shahzaib
Thanks

Report message to a moderator

Re: Converting Data from Excel to Database of Oracle [message #132715 is a reply to message #132690] Mon, 15 August 2005 19:01 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Search this forum for 'excel'. There are numerous links. Read, at least, three from top to bottom and then come back to us with any specific questions.

Update: Searching for 'ora_ffi' will give better results for 'reading' and updating an excel spreadsheet. Search 'text_io' and 'utl_file' for writing new 'csv' files.

David

[Updated on: Mon, 15 August 2005 19:05]

Report message to a moderator

Re: Converting Data from Excel to Database of Oracle [message #132775 is a reply to message #132690] Tue, 16 August 2005 02:09 Go to previous message
rzkhan
Messages: 370
Registered: March 2005
Senior Member
u can also use sqlloader that ships with oracle. make a .csv file and use sqlloader.
hope this works

riaz

Report message to a moderator

Previous Topic: display the record count numbers
Next Topic: Reg Raise FORM_TRIGGER_FAILURE
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 03:44:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.