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 / 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


Please Help Members By Posting Answers For Below Questions

What is the license for clipper?

533


Can I use google sheets as a database?

457


How do I check my drivers?

470


What is rdms?

489


How do you link a spreadsheet to a website?

480






What is a Federated Query ?

591


Why is database important?

512


Is it possible to break netlibs encryption?

511


Which two can be implemented as a centrally located logical architecture?

534


How to stop superserver service on linux using only firebird tools?

609


What is partial key?

596


What is the quickest sorting method to use?

541


What is structure of dbms?

488


What do you mean by e-r model & object-oriented model?

501


What is bcnf standard form in dbms?

551