I have one Excel file with 80,000 Records. Now I need to
load that whole file into Oracle Database with same columns
in Excel sheet .
How can i do that?
- 3 Answers
- 5051 Views
- I also Faced
- E-Mail Answers
Answer Posted / bibekananda pradhan
An excel file cannot store more than 64K records.
To load an excel file, we will have to convert it to a
delimited format. the load it using sqlldr
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is inner join in database?
What is environment of openedge?
Why is databases important in healthcare?
What is service based database?
Can you explain the select into statement?
What is database partition key?
What is procedure in database?
What is the difference between case version and decode version?
What is acid property in dbms?
Is there a database program for mac?
Do we consider null values the same as that of blank space or zero?
What is record in a database?
What is the largest component of a database?
Explain some of the uses of openedge architect features useful for a developer?
What does clipper stand for?
