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

On 5/17/06, vikram singh <vikramsingh120_at_gmail.com> 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_at_gmail.com
------------------------------------------------------------------------
"All the girls say
Save a horse, ride a cowboy."
--
http://www.freelists.org/webpage/oracle-l