OraFAQ Forum: General » Excel to ORACLE

Home » Other » General » Excel to ORACLE

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Excel to ORACLE [message #101989]

Tue, 01 January 2002 14:52

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.

----------------------------------------------------------------------

Report message to a moderator

Re: Excel to ORACLE [message #101992 is a reply to message #101989]

Thu, 03 January 2002 03:49

Frank Naude
Messages: 4581
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

----------------------------------------------------------------------

Report message to a moderator

Re: Excel to ORACLE [message #102290 is a reply to message #101989]

Thu, 18 April 2002 03:49

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

Report message to a moderator