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

Define RDBMS.

1123


What are the benefits of database management system?

954


What is a relation schema?

903


What do you understand by aggregation and atomicity?

851


what is scan listener.

2179


What is the use case where we can use stretch database?

878


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

879


Enlist the cursor types.

982


Why do we study dbms?

874


What is a Built_in subprogram ?

3924


How to do replication of firebird databases?

888


What are vdl and sdl?

1074


Do I need ccp4?

918


Explain Relational Algebra in RDBMS

1018


I have a table which has lot of inserts, is it a good database design to create indexes on that table?

842