Re: How to Import data from execl to Oracle Automatically

Pawan wrote:
> I want to import excel sheet to Oracle database. But not manually. It
> should be automatic. Is there any way...?

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10743/data_access.htm#sthref3743

There's also some oraxcel.com, but I don't know anything about it.

For a more simplistic way, you can export to csv and use external tables
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10743/bus_intl.htm#i31994 or sql*loader.

jg

--
@home.com is bogus.
First, we kill all the lawyer's Blackberries:
http://www.signonsandiego.com/news/business/20050716-9999-1b16metabo.html