OraFAQ Forum: Server Utilities » inserting rows from a excel or 123 file

Home » RDBMS Server » Server Utilities » inserting rows from a excel or 123 file

Thu, 01 May 2003 22:58

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.

Fri, 02 May 2003 10:46

Mahesh Rajendran
Messages: 10707
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)

Previous Topic:	DB400 access
Next Topic:	Index copy

Goto Forum:

]

Current Time: Wed Jun 26 12:45:42 CDT 2024