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:

By: Jayaram Krishnaswamy

Poor Best

Rating:

/ 31

September 26, 2006

print this article

SEARCH DEV SHED

TOOLS YOU CAN USE

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.

Next: Providing details of the file >>