Re: data import from Lotus or Excel to Oracle 8i

If you can get the data in a flat file format, you can user SQL*Loader to load the data into the database. Basically this involves creating tables to put the data into, creating the flat files from Lotus (comma-delimited, for example), and writing SQL*Loader control files. Syntax for writing and calling control files can be found in the on-line documentation from Oracle's web site. It's not terribly tricky, check out the examples in the documentation. Oracle actually did a decent job of documenting SQL*Loader.

Perhaps there are other ways to import the data over, but I'm not familiar with them.

In article <876ttu02og7_at_enews4.newsguy.com>,   "Lesley Boughner" <lesley_at_vimich.com> wrote:
> Hello everyone!
> Please excuse my lack of knowledge in Oracle 8i, I've just been put on
this
> project 2 days ago and I must admit I'm a little overwhelmed. We're
in a
> crunch and I don't have a lot of time to take my time and research and
learn
> oracle the way I'd like to.
>
> I'm looking for the best way to import data from Lotus or Excel
(doesn't
> matter whichever is easier, the data is currently in DataEase) into
Oracle
> 8i. Do I have to write batch files or a VB procedure? (I'm a vb
programmer
> so that's what I know) Could anyone point me in the right direction -
to
> articles or a book in particular that would help me with.
>
> Thank you in advance for any suggestions.
> Lesley Boughner
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 01 2000 - 12:02:30 CST