Home » RDBMS Server » Server Utilities » inserting rows from a excel or 123 file
inserting rows from a excel or 123 file [message #72286] Thu, 01 May 2003 22:58 Go to next message
Venu
Messages: 44
Registered: September 1999
Member
hi

Is there any way to insert records from a excel or 123 file.? plz mail me the solution as its very urgent for me.
Thanks in advance.

Report message to a moderator

Re: inserting rows from a excel or 123 file [message #72294 is a reply to message #72286] Fri, 02 May 2003 10:46 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
create a csv file from the excel.
use sql*loader to load it into database.
for more details, look into oracle docs ( utilities manual)

Report message to a moderator

Previous Topic: DB400 access
Next Topic: Index copy
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 06:46:41 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.