?
Solved

Converting Excel file to Oracle using SQLLDR

Posted on 2007-03-18
6
Medium Priority
?
1,311 Views
Last Modified: 2008-09-08
How can I import excel file to Oracle using Sql Loader in Oracle 9i for Windows Operating System.
0
Comment
Question by:samisyed
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
6 Comments
 
LVL 45

Accepted Solution

by:
patrickab earned 252 total points
ID: 18747239
samisyed,

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

Patrick
0
 
LVL 12

Assisted Solution

by:RubenvdLinden
RubenvdLinden earned 248 total points
ID: 18748466
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
 
LVL 45

Expert Comment

by:patrickab
ID: 18748654
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
 
LVL 12

Expert Comment

by:RubenvdLinden
ID: 18916348
Any updates on your problem?
Is it working now?
0

Featured Post

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question