How to insert bulk data into the oracle database from excel sheet ?

  • Interview Candidate
  • 3
  • 4616

Showing Answers 1 - 3 of 3 Answers

G. Sreedhar

  • Sep 26th, 2007
 

Actually there are several ways of importing the data from Excel files to Oracle database.

1) Save the .xls file to .csv file and then by using TXT2SQL tool we can generate the code and execute the code in TOAD or SQL prompt.

2) By using SQL*LOADER we can import the data from excel to oracle database.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions