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?
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 the use of PARFILE option in EXP command ?
What is the use of CONSTRAINTS option in EXP command ?
What are procedures in dbms?
What is implicit cursor in dbms?
What is view dbms?
What are the SQL clauses supported in the link property sheet ?
What do you mean by durability in dbms?
How we can connect the Webform pages with database?
What do you understand by b-trees?
Can group by and ordered by used in a single query?
Which is better saving files in database or in file system?
How to change database dialect?