use oraxls tool.
----- Original Message -----
From: "Prity Ladsaria Roy "
<oracledba-ezmlmshield-x17251369.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, March 30, 2006 3:48 PM
Subject: Re: import data from excel files


> create a table that matches your excel file.
>
> convert the xls to csv (Comma separated values).
>
> and use SQLLoader.
>
> I think it should work
>
> Prity
>> hi,
>> I am using oracle 9i on windows 2000 server.
>> I want to import data from a excel file. How it is possible through
>> OEM or command prompt ?
>>
>> Thanks in Advance.
>> satish jain
>>
>>
>>
>>
>> --------
>> 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
>>
>>
>
>
>
> --------
> 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