Home arrow Oracle arrow Importing a CSV Text File into Oracle 10G XE

Importing a CSV Text File into Oracle 10G XE

If you need to deal with legacy data by moving it to more recent databases, this article might help. It will show you how to move data from an MS Excel file into an Oracle 10G XE table.

TABLE OF CONTENTS:
  1. Importing a CSV Text File into Oracle 10G XE
  2. Exporting the Employees table from MS Access
  3. Importing the EmployeesCsv.csv file into Oracle 10G XE
  4. Providing details of the file
By: Jayaram Krishnaswamy
Rating: starstarstarstarstar / 31
September 26, 2006

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

Introduction

In an earlier article, importing data in a spreadsheet into Oracle 10G XE was described. The present article looks at importing a Comma Separated Value (CSV) file, used commonly in exporting MS Excel files, into an Oracle 10G XE table. CSV files are very popular and frequently used data transformation formats since legacy data are usually of this type. In recent times XML formatted data has replaced them. 

However, there is a whole lot of legacy data that needs to be loaded on to more recent databases. Hence, every database vendor provides a program to accomplish this conversion. Also programs exist which takes a CSV file and convert it into an XML file. Perhaps this is another route one can take in data conversions for legacy data.

The CSV file used in this tutorial

In order to load a CSV file to a table in Oracle 10G XE, a CSV file will be created from an Access database table in this tutorial. This will not only simplify the process of understanding the procedure, but also gives us an opportunity to correctly implement the conversion, since the original data, with a good design, is available at the outset. The table we will be using to create a CSV file is the Employees table in the Northwind.mdb, an MS Access database whose design view is as shown.



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