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
- 4827 Views
- I also Faced
- E-Mail Answers
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 'cross join'? Or what is cartesian product?
Explain the terms database and dbms?
Is the internet a database?
What do you mean by super key, primary key, foreign key and candidate key?
What are the functions of rdbms?
All questions related to Control m monitoring tool
How do I check my drivers?
What is the purpose of database?
What is difference between database and schema?
Explain Enterprise Resource Planning (ERP), and what sort of a database is utilised in an ERP application?
Explain some of the uses of openedge architect features useful for a developer?
Enlist the various relationships of database.
Explain why an information gap exists in most organizations.
What is sonicmq?
What methods is used to commit the changes made in DataSet object?
