?
Solved

Upload excel file to oracle data base

Posted on 2009-07-15
3
Medium Priority
?
552 Views
Last Modified: 2013-12-19
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.

Thanks
Mostafa
0
Comment
Question by:Mostafa_ElSadek
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 14

Accepted Solution

by:
shru_0409 earned 1000 total points
ID: 24857329
0
 
LVL 10

Assisted Solution

by:ravindran_eee
ravindran_eee earned 1000 total points
ID: 24866616
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

http://www.orafaq.com/wiki/SQL*Loader_FAQ
http://www.oracleutilities.com/OSUtil/sqlldr.html
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question