External table is one option too.

Regards

Deepak
----- Original Message -----
From: "maharajan" <oracledba-ezmlmshield-x54432409.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Monday, January 31, 2005 4:16 PM
Subject: Data load help


>
> Hi gurus
> How do we load data from excel sheet/csv file into a table.is there any
> other option than utl_file and sql loader package.In utl_file pkg case
> we have to edit the init ora file .also the file and path of the excel
> sheet is required .so can any one say whether the physical path is
> enough to be specified
> Tia
> maharajan
>
>
>
> Confidentiality Notice
>
> The information contained in this electronic message and any attachments
to this message are intended
> for the exclusive use of the addressee(s) and may contain confidential or
privileged information. If
> you are not the intended recipient, please notify the sender at Wipro or
[Email address protected] immediately
> and destroy all copies of this message and any attachments.
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page