Home » SQL & PL/SQL » SQL & PL/SQL » How to insert record of excel worksheet in to Oracle
How to insert record of excel worksheet in to Oracle [message #23709] Mon, 30 December 2002 08:12 Go to next message
Dhiren Patel
Messages: 16
Registered: December 2002
Junior Member
No Message Body

Report message to a moderator

Re: How to insert record of excel worksheet in to Oracle [message #23713 is a reply to message #23709] Mon, 30 December 2002 08:39 Go to previous messageGo to next message
Remi Visser
Messages: 44
Registered: December 2002
Member
Dump it to a csv (comma sepreated file ) and use SQL*Loader to insert the file in a table.

Good luck!

Report message to a moderator

Re: How to insert record of excel worksheet in to Oracle [message #23719 is a reply to message #23709] Mon, 30 December 2002 09:25 Go to previous message
Mark
Messages: 284
Registered: July 1998
Senior Member
The idea is to get the data from Excel into a flat file that is seperated by commas, and then load that into the db via sql_loader: for examples go to:
http://www.orafaq.net/faqloadr.htm#HOW
In Excel use save as, and save the data in format .cvs

Report message to a moderator

Previous Topic: excel to oracle (WHat csv file ?)
Next Topic: How to insert a long Raw
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jun 10 15:19:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.