Home arrow Oracle arrow Page 2 - Loading Spread Sheet Data into Oracle 10G XE

Loading the XLS file into Oracle - Oracle

If you have ever loaded data into an Oracle table, you know that it is a rather complicated process. You will be surprised at how much easier it is to do in Oracle 10G XE. Keep reading to find out.

TABLE OF CONTENTS:
  1. Loading Spread Sheet Data into Oracle 10G XE
  2. Loading the XLS file into Oracle
  3. Loading the Spread Sheet into Oracle XE
  4. Continuing to Load
By: Jayaram Krishnaswamy
Rating: starstarstarstarstar / 29
July 26, 2006

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

Log into HR Database

Log into the Oracle sample database HR using the short-cut hyperlink Go To Database Home Page... from All Programs-->Oracle 10g Database Express Edition. This opens up the login page for the HR database. Assuming you have already permitted the hr user with hr password for the database, you can enter the credentials and get access to the database as shown in the next picture.

Move to Home

After the login is accepted you will find the Home page of the HR database, where you will find a number of icons. These were already explained in my first tutorial on this topic on the DevShed site. Please review the previous tutorials and the two more that followed. Click on the Utilities icon, and from the drop-down click on the Load item.

Change to Data Load/Unload

In this window you can load several different formats of data including Text, Spread Sheet and XML. We will be loading the Employees.XLS we created from the Northwind database, therefore click on Load SpreadSheet Data icon.



 
 
>>> More Oracle Articles          >>> More By Jayaram Krishnaswamy
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

ORACLE ARTICLES

- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: