Home arrow Oracle arrow Loading Spread Sheet Data into Oracle 10G XE

Loading Spread Sheet Data into Oracle 10G XE

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

Introduction

SQL*Loader, Oracle's utility program, was used to load data into an Oracle table. The program needed two files, a data file and a control file. The control file with the file extension .ctl controlled the file to be saved, errors in loading, and so forth. SQL*Loader also required the SQL*Net program. It also created a log file, giving further information on the loading. All this is simplified in Oracle 10G XE. If you know Cntr+C and Cntr+V, your loading is almost finished.

This tutorial is about loading an Excel spread sheet into an Oracle table. It's very easy and you will be surprised at its simplicity. The tutorial also shows what can go wrong and how to fix it in a simple case. The tutorial uses a table (Employees) from the Northwind database.

Creating a test spread sheet

A test spread sheet was created by exporting a table from Northwind.mdb to an Excel file. The is easily accomplished from File-->Export which brings up the window Export Table 'Employees' to... , at which point you use the SaveAsType drop-down to pick up the Microsoft Excel 97-2003 *xls format. Give it a name and it will be saved to the same default directory, C:MY Documents. The exported table had the design parameters shown in the next picture. The reason for choosing this file was that it had different data types with different formatting options.



 
 
>>> 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: