Home » SQL & PL/SQL » SQL & PL/SQL » put data from excel to database
put data from excel to database [message #197009] Mon, 09 October 2006 09:37 Go to next message
srinivas.k2005
Messages: 334
Registered: August 2006
Senior Member
Hi all,

How to insert data into database fetching data from excel
report.Please give me an idea.

Thanks in advance,
Srinivas
Re: put data from excel to database [message #197012 is a reply to message #197009] Mon, 09 October 2006 09:50 Go to previous messageGo to next message
rigatonip
Messages: 50
Registered: December 2005
Member
Here's a link to some ideas from this forum.

http://www.orafaq.com/forum/t/70228/80628/
Re: put data from excel to database [message #197023 is a reply to message #197012] Mon, 09 October 2006 10:48 Go to previous messageGo to next message
srinivas.k2005
Messages: 334
Registered: August 2006
Senior Member
Hi,

But the fields are separated with comma's.In the link You
provided .But i have the data in cells.Any idea when the
fields are in cells.

Thanks,
Srinivas
Re: put data from excel to database [message #197048 is a reply to message #197009] Mon, 09 October 2006 13:16 Go to previous messageGo to next message
rigatonip
Messages: 50
Registered: December 2005
Member
Can you just save the data off as a comma separate value file from Excel and then operate on it?
Re: put data from excel to database [message #197053 is a reply to message #197009] Mon, 09 October 2006 14:46 Go to previous messageGo to next message
Bill B
Messages: 1482
Registered: December 2004
Senior Member
In excel use the 'save as" and select the type to be csv
Re: put data from excel to database [message #197158 is a reply to message #197009] Tue, 10 October 2006 05:19 Go to previous messageGo to next message
rikfair
Messages: 22
Registered: October 2006
Location: UK
Junior Member
Hi

The following article explains how to automatically convert excel documents to csv files which can be read by the database

http://www.astral-consultancy.co.uk/cgi-bin/hunbug/doco.cgi?11030

Then you could refer to this document to create external tables based on these csv files

http://www.astral-consultancy.co.uk/cgi-bin/hunbug/doco.cgi?11210

Razz
icon7.gif  Re: put data from excel to database [message #197514 is a reply to message #197009] Wed, 11 October 2006 09:53 Go to previous messageGo to next message
aladdha
Messages: 4
Registered: October 2006
Location: Mumbai
Junior Member

Hi,
You can user either External Table or SQLLOADER, and as you want to insert data from excel to database SQLLoader is the only utility i think...
for that u need to create a control file which will call excel file (need to be saved as .csv) then you can load data through this.
Re: put data from excel to database [message #203294 is a reply to message #197009] Tue, 14 November 2006 12:06 Go to previous message
srinivas.k2005
Messages: 334
Registered: August 2006
Senior Member
Thanks its working
Previous Topic: Sql toughest query
Next Topic: last record in a table
Goto Forum:
  


Current Time: Mon Dec 05 03:11:12 CST 2016

Total time taken to generate the page: 0.13594 seconds