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
>
>


Oracle LazyDBA home page