import from excel to oracle 9i

25 pts.
Tags:
Microsoft Excel
Microsoft Excel import/export
Oracle 9i
Oracle 9i import/export
how can i import data from excel to oracle 9i?

Answer Wiki

Thanks. We'll let you know when a new response is added.

One option is saving the excel file in CSV format, and then load it into the database using <a href=”http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/part2.htm#436160″>SQL*Loader</a>.

Also, you could use a tool, such as <a href=”http://sourceforge.net/projects/quickload/”>QuickLoad</a>

———————————–

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Lusy
    You have to use sql loader. For that you have have to create a control file specifying the input file format. See the example: http://www.oreilly.com/catalog/orsqlloader/chapter/ch01.html#43545 For more information please visit at: www.iyogi.net
    825 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following