Home » Other » General » Excel to ORACLE
Excel to ORACLE [message #101989] Tue, 01 January 2002 14:52 Go to next message
j.smith
Messages: 21
Registered: December 2001
Junior Member
here is my delima. I have a excel spread sheet. with 8 tables, each table with 7 columns, and a couple thousands rows of data. I want to put all those rows into a new oracle database im creating. Any suggestions on how do this. I really do not want to type out all the rows into oracle.

----------------------------------------------------------------------
Re: Excel to ORACLE [message #101992 is a reply to message #101989] Thu, 03 January 2002 03:49 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

You can easily convert your Excel spreadsheets into CSV files. Transfer or FTP these files to you Oracle Server and use SQL*Loader to load the data into Oracle. See the Oracle Loader FAQ (http://www.orafaq.net/faqloadr.htm) for details.

Best regards.

Frank Naude

----------------------------------------------------------------------
Re: Excel to ORACLE [message #102290 is a reply to message #101989] Thu, 18 April 2002 03:49 Go to previous messageGo to next message
Kashyap Mehta
Messages: 1
Registered: April 2002
Junior Member
Hello,

I have Oracle 8i Server running on Windows 2000 Server.
I want to transfer data from my Excel (CSV file) application to Oracle tables. Can you guide me how this can be possible.

Rgds,

Kashyap. Mehta
Re: Excel to ORACLE [message #102378 is a reply to message #101989] Wed, 15 May 2002 10:12 Go to previous messageGo to next message
Elango
Messages: 2
Registered: May 2002
Junior Member
i want the below method,
convert execl sheet to oracle database
Re: Excel to ORACLE [message #102565 is a reply to message #101989] Sun, 21 July 2002 22:14 Go to previous messageGo to next message
Wien
Messages: 1
Registered: July 2002
Junior Member
Hi, you can use SQL loader to do that.
It is easy and fast.
Re: Excel to ORACLE [message #102848 is a reply to message #101992] Wed, 23 October 2002 03:13 Go to previous message
markku uronen
Messages: 1
Registered: October 2002
Junior Member
No Message Body
Previous Topic: Re: Codd's Rule of RDBMS URGENT
Next Topic: Oracle Instances
Goto Forum:
  


Current Time: Fri Mar 29 03:57:16 CDT 2024