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?
- 3 Answers
- 6023 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / ur_momma
Sqlldr is kinda oldschool these days, external tables is
the way to do it with the delimited file.
| Is This Answer Correct ? | 3 Yes | 2 No |
What is correlated subquery in dbms?
Whats is an OLTP Database
What are the the different Data Manipulation Language statements are?
What is the use of TABLES option in EXP command ?
how to solve cardinality in dbms...many to many ralationships
What are the four components of a database system?
What is alternate key?
What is a logical backup ?
What is the difference between a MESSAGEBOX and an ALERT ?
What is the best way to determine whether firebird server is running?
How data are stored in database?
What is different keys in dbms?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
