Re: Importing Excel sheet data into ORacle8i

From: Thomas Warnecke <cis_at_caoc2.de>
Date: Fri, 9 Mar 2001 08:17:34 +0100
Message-ID: <989vdj$drk$04$1@news.t-online.com>

Hi,

I work with Oracle 7.2.3 and had the same problem. I stored the excel data in the CSV format and the I used Perl ( with DBI for Oracle ) to import.

Thomas Warnecke

"Sarma Venkata Subramanyam Tiru" <tvssarma_at_yahoo.com> wrote in message news:20010309061013.90372.qmail_at_web11208.mail.yahoo.com...
> Hello,
> I have a problem here. I am getting records of the magnitude of thousands
in
> excel format.
> I want to import this data into Oracle 8i database at a partcular time
> everyday. Is there any way that can be done?
> There are two points to the question
> 1. How do I import the excel data into Oracle 8i?
> 2. How do I automate the process
>
> The Oracle 8i database is being hosted on Sun Solaris
> Help is welcome
>
> __________________________________________________
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
>
> --
> Posted from web11208.mail.yahoo.com [216.136.131.190]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Fri Mar 09 2001 - 01:17:34 CST