Data from Excel sheet to oracle table [message #327323] |
Mon, 16 June 2008 01:20  |
ram anand
Messages: 244 Registered: February 2008 Location: india
|
Senior Member |
|
|
Hi,
I am having more than 5lakhs records how to insert a bulk data from excel sheet to oracle table,pls give the steps to load the datas into the table
Thanks in Advance
|
|
|
|
|
Re: Data from Excel sheet to oracle table [message #327451 is a reply to message #327323] |
Mon, 16 June 2008 08:04   |
jaganerp@gmail.com
Messages: 63 Registered: April 2008
|
Member |
|
|
by useing sqlloader u have to insert bulk of record's ata time
systax
load data
infile "c:\jagan\data.csv"(your file path csv is the extenction of xl sheet )
into tablename
fildsterminated by "," optionally enclosed by"'"
(column1,column2...)
after that u have to connect with dos prompt and find out you are sqlloader file directory theer u will give
sqlldr user=username/password@host control=c:\jagan\controlfile.ctl(u r control file path)
run you are script like this after runing it show's the message inserted record's and rejectd recods
that message stores in log file
|
|
|
|