Re: Importing Excel sheet data into ORacle8i

From: Gerrit Linker <gjlinker_at_oraxcel_no>
Date: Fri, 30 Mar 2001 22:52:55 +0100
Message-ID: <9a2v5r$fld$1@news.europeonline.net>

This is a perfect application for SQL*XL! SQL*XL is an addin for Excel that adds full Oracle access to Excel. Together with Excel macros which it fully supports you can develop a macro solution. Most of the code you need to write will be generated for you even!

Have a look at SQL*XL at http://www.oraxcel.com

Pointers to do your automation:
Manually insert some data into your table and record the whole process including signing on/off as an Excel macro. Look at the generated code and replace hard coded values with variables. Then Write a call to this macro in the ThisWorkbook object in the Workbook_Load event. The only thing that is left to do is some housekeeping (clearing off old stuff in the workbook before you start again, etc) and to schedule the execution of the spreadsheet. You can use some NT schedulers and there is tons of shareware out there that can do it as well. A VB programmer will knock something up in milliseconds...

Greetings,

Gerrit-Jan Linker

"Terry Dykstra" <dontreply_> wrote in message news:49ar6.10371$Lm2.1279488_at_news0.telusplanet.net...
> Infomaker by Sybase can pipe between any 2 databases, e.g. Excel and
Oracle.
> You can create an exe which allows you to schedule when the pipeline runs.
>
> --
> Terry Dykstra
> Canadian Forest Oil Ltd.
> "Sarma Venkata Subramanyam Tiru" <> 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 30 2001 - 15:52:55 CST