Upload excel file to oracle data base

I have Excel file as a template with 10 columns need to be uploaded to oracle so I need the SQL statment that can read the excel file and update the oracle fields. I'm using Oracle 9i with Excel 2003.

Who is Participating?
shru_0409Connect With a Mentor Commented:
ravindran_eeeConnect With a Mentor Commented:
If you have TOAD, you can load the EXCEL file easily into the DB.
If you cannot install any application on the server, then I would suggest making use of SQL Loader. For this you need to save the XLS file as CSV file first. Then write some simple code to load the data into tables. Check the below links for making use of SQL Loader utility

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.