Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is concept of dbms?

905


Explain the functionality of dml compiler.

999


Explain what is meant by asymmetrical protocols?

1099


Do models have limitations?

885


What are database modules?

916


What is rdbms with diagram?

878


What do you mean by index hunting?

1089


What do you know about DBMS?

1005


How many types of users in dbms?

894


How to find the size of database?

1032


What is the best database management system?

981


What are the advantages of database system?

935


How is a database related to a table?

963


Give us a non-computer example of preemptive and non-preemptive scheduling?

917


Which free database is best?

851