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?
Answer Posted / shamimul
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 ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is concept of dbms?
Explain the functionality of dml compiler.
Explain what is meant by asymmetrical protocols?
Do models have limitations?
What are database modules?
What is rdbms with diagram?
What do you mean by index hunting?
What do you know about DBMS?
How many types of users in dbms?
How to find the size of database?
What is the best database management system?
What are the advantages of database system?
How is a database related to a table?
Give us a non-computer example of preemptive and non-preemptive scheduling?
Which free database is best?