Re: how to load data from Excel sheet into Oracle tables using SQL*LOADER

  • From: "bill thater" <shrekdba@xxxxxxxxx>
  • To: vikramsingh120@xxxxxxxxx
  • Date: Wed, 17 May 2006 09:31:31 -0500

On 5/17/06, vikram singh <vikramsingh120@xxxxxxxxx> wrote:


Hi All, Is there a way to load data from an Excel sheet into an Oracle table using SQL*Loader? I know there must be. Please, can anyone help me out how this can be achieved. Thanks in advance.


Vikram.

well, one way is to save the data to a delimited file and then set up the loader control file to read the delimited file.

but that may not be the best way, it depends on the complexity of the
data, and the size of the file.
--
--
Bill "Shrek" Thater     ORACLE DBA
      shrekdba@xxxxxxxxx
------------------------------------------------------------------------
"All the girls say
Save a horse, ride a cowboy."
--
//www.freelists.org/webpage/oracle-l


Other related posts: