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

Importing the EmployeesCsv.csv file into Oracle 10G XE - Oracle

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

Log into Oracle 10G XE, which brings up the next screen with several icons for the various areas, such as Administration, Object Browser, etc. Click on the Utilities icon and from the drop-down go to the Data Load/Unload drop-down in which you click on the Load menu item as shown.

This brings you to the next screen where you can Load Text Data, Load Spreadsheet Data or Load XML Data.

Click on the icon for loading text data which brings up the next window. The picture has been rearranged in this view. If the file size is less than 30KB, Oracle 10g XE supports cut and paste, not only for CSV files but also spreadsheet files. The other option is to upload a file, either comma delimited or tab delimited as shown. This option is chosen for this tutorial.

In the above screen choose to Upload a file and choose to load into a New table. This completes the target and method task on the left hand side. Click on the Next button.



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