import from excel to oracle 9i
Home > IT Answers > Oracle > import from excel to oracle 9i
Binty
25 pts.
0
Q:
import from excel to oracle 9i
Oracle 9i import/export, Microsoft Excel import/export, Oracle 9i, Microsoft Excel
how can i import data from excel to oracle 9i?
ASKED: Jul 11 2009  7:45 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mraman
260 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
One option is saving the excel file in CSV format, and then load it into the database using SQL*Loader.

Also, you could use a tool, such as QuickLoad

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

A third option would be to use ODBC from excel to tie to an Oracle table that has the exact same layout as your oracle spreadsheet. then cut/paste your rows into the excel sheet and let it save the data.

This works as long as your datatypes match up correctly and as long as your data contains all of the same datatype. Excel assumes that the first row it loads defines the datatype for all subsequent rows. Excel then goes on to interpret numbers in each column differently from strings in the same column so thanks to excels dynamic treatment of values may have issues on certain situations. Make sure to check your results after you load.

Good luck, Kevin

--------------------------------
SQL loader is the best choice, you can use a direct loading for faster performance.
Cheers - Muthu
Last Answered: Sep 4 2009  6:44 AM GMT by Mraman   260 pts.
Latest Contributors: FlaviusMaximus   180 pts., Carlosdl   29820 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Lusy   825 pts.  |   Jul 13 2009  4:54AM GMT

You have to use sql loader. For that you have have to create a control file specifying the input file format.

See the example: <a href="http://www.oreilly.com/catalog/orsqlloader/chapter/ch01.html#43545" title="http://www.oreilly.com/catalog/orsqlloader/chapter/ch01.html#43545" target="_blank">http://www.oreilly.com/catalog/orsqlload…</a>

For more information please visit at: <a href="http://www.iyogi.net" title="http://www.iyogi. " target="_blank">www.iyogi.net</a>

 
0