Converting Excel file to Oracle using SQLLDR

How can I import excel file to Oracle using Sql Loader in Oracle 9i for Windows Operating System.
samisyedAsked:
Who is Participating?
 
patrickabConnect With a Mentor Commented:
samisyed,

First save your Excel worksheet as text, then use SqlLoader to load the contents of the text file into Oracle.

Patrick
0
 
RubenvdLindenConnect With a Mentor Commented:
First, like patrickab said, you have to save your excel file as a Comma Seperated Values (csv) file.
Next, you can load it to Oracle using SQL*Loader.

This is a nice article to get you started with SQL*Loader:
http://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0,295199,sid63_gci977861,00.html

Please let me know if you have additional questions.
0
 
patrickabCommented:
As a follow-up:

To convert an Excel file to a CSV file, just go to File/Save As and select the filetype as CSV - that's all that's needed. After that SqlLoader will accept the data as a string of data from the CSV file.
0
 
RubenvdLindenCommented:
Any updates on your problem?
Is it working now?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.