Home » SQL & PL/SQL » SQL & PL/SQL » Data from Excel sheet to oracle table (oracle 10g)
Data from Excel sheet to oracle table [message #327323] Mon, 16 June 2008 01:20 Go to next message
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 #327327 is a reply to message #327323] Mon, 16 June 2008 01:31 Go to previous messageGo to next message
kathiresan.c
Messages: 23
Registered: February 2008
Location: Tamil Nadu, India
Junior Member
Hi Ram anand,

you can use SQL loader for inserting huge amount of data...

It's simple way to insert lot of records...

Steps are following:

1. Convert excel file to .csv(Extention) file..
2. you have to write Control file
3. Excute it in your OS command


For More Information .. Read this
http://www.orafaq.com/wiki/SQL*Loader_FAQ
Re: Data from Excel sheet to oracle table [message #327329 is a reply to message #327327] Mon, 16 June 2008 01:37 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Search the board

This has been adressed many times
Re: Data from Excel sheet to oracle table [message #327451 is a reply to message #327323] Mon, 16 June 2008 08:04 Go to previous messageGo to next message
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
Re: Data from Excel sheet to oracle table [message #327463 is a reply to message #327451] Mon, 16 June 2008 08:31 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
@jaganerp@gmail.com

Read and FOLLOW OraFAQ Forum Guide.

Regards
Michel

Previous Topic: Ref cursor
Next Topic: Alter table constraint help
Goto Forum:
  


Current Time: Thu Dec 08 16:21:01 CST 2016

Total time taken to generate the page: 0.23653 seconds