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

Exporting the Employees table from MS Access - 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

Click on the File menu and in the drop-down, click on Export... which opens the window Export Table 'Employees' To.... Click on the drop-down for Save As type: Text Files(*.txt;*.CSV;*.tab;*.asc) and then click on the button Export. You will have to type in the extension type from among the four choices shown; the default is *.txt. Again by default the file will be saved to the My Documents folder as shown.

When the button Export All, which gets enabled, is clicked, the Export Text Wizard comes up as shown. It is already showing that a delimited character will separate the fields. Fixed width will be another option for the export process, if that restriction is acceptable. It also shows a sample of how the export looks, showing the columns.

When you click on the Next button in the above screen you will shift to the next screen shown here, which comes up with the default choice selecting comma as the delimiter between the fields. Since column names are important for the table that will be created in Oracle 10G XE, make sure you place a check mark on the check box marked Include Field Names for First Row. Click on the Next button. The choice of what Text Qualifier to use is also important as discussed later.

This brings you to the final screen showing that the EmployeesCsv.CSV file will be saved to the location shown in the Export to File: textbox.

When you click on the Finish button, you get the final screen showing where you can find your file.

The next picture shows a part of the exported EmployeesCsv.csv file opened using Notepad. Notice that all fields are enclosed in double quotes. The very first line has the names of the column. Also note the column values for the 'Photo' column are all empty. The picture shows text corresponding to only two rows in the original table. It will be useful to open this file using MS Excel to verify that the table is faithfully reproduced in the CSV file.



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