Home » SQL & PL/SQL » SQL & PL/SQL » How to import excel data to oracle table?
How to import excel data to oracle table? [message #247539] Tue, 26 June 2007 05:33 Go to next message
fortunethiyagu
Messages: 94
Registered: December 2006
Member

Hi..

Im having 5 columns in excel, filled with data.

Now i want to push the data into oracle table...

how to do it?

anyone having code to do same?

help me...

thiyagu
Re: How to import excel data to oracle table? [message #247543 is a reply to message #247539] Tue, 26 June 2007 05:50 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Transform the XLS file to a CSV and load it through SQL Loader.

MHE
Re: How to import excel data to oracle table? [message #247547 is a reply to message #247539] Tue, 26 June 2007 06:06 Go to previous messageGo to next message
sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata
Senior Member

If you are searching for a tool then try with goldensoftware.com using impexp32 utility
First copy the data in a plain txt file then import it using ImpExp32 tool.

Regards,
Sanka
Re: How to import excel data to oracle table? [message #247565 is a reply to message #247539] Tue, 26 June 2007 06:53 Go to previous message
rajvaida
Messages: 26
Registered: May 2006
Location: India
Junior Member

check the following link http://www.orafaq.com/forum/t/15042/0/.

[Updated on: Tue, 26 June 2007 07:08]

Report message to a moderator

Previous Topic: T -SQL to PL/SQL conversion
Next Topic: Displaying the Results based on the attached excel formulae. do not answer me, i am willing to wait.
Goto Forum:
  


Current Time: Sun Dec 04 04:58:35 CST 2016

Total time taken to generate the page: 0.13748 seconds