Oracle XE-Data Uploading from CSV file

This is a step-by-step guide on the simplest of the simplest ways by which data can be uploaded from CSV file to Oracle table. I have done uploading using this way for as many as 10,000 records without any performance issues. It went very swiftly.

Login to OracleXE first and follow the instructions below:

Step 1 - Click Utilities


Step 2 - Click Data Load/Unload


Step 3 - Click Load


Step 4


Step 5 - Click Load Spreadsheet Data


Step 6 - Follow the screen


Step 7 - Follow the screen


Step 8 - Follow the screen


Step 9 - Follow the screen


Step 10 - Follow the screen


Posted by Labels: , , , , ,

4 comments :

  1. AnonymousMarch 19, 2009 at 10:21 AM

    Is there any pl/sql way to upload data from CSV to oracle table

    ReplyDelete
  2. Anantha NarayananMarch 19, 2009 at 1:18 PM

    There are many possibilities to do that, but probably the easiest one is via a databaselink from Oracle to Excel, after configuring ODBC (Open DataBase Connectivity).

    More details can be found on: http://www.e-ammar.com/Oracle_TIPS/HS/configuring_generic_database_con.htm

    ReplyDelete
  3. UnknownDecember 10, 2009 at 8:00 PM

    I have a question regarding the upload data from excel. I am getting error saying that file can't be larger than 32kb. I tried as script also and its the same problem. I have system admin rights but didn't find where to increase the maximum script byte size. Can you please help me with this? Thanks,

    ReplyDelete
  4. bin3rJanuary 14, 2010 at 10:04 AM

    Is there this tools can used with dblink

    ReplyDelete

Subscribe to: Post Comments ( Atom )