Importing a CSV Text File into Oracle 10G XE - Importing the EmployeesCsv.csv file into Oracle 10G XE (
Page 3 of 4 )
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.