Re: Import Excel spread sheet to ORacle

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 27 Feb 2000 22:24:53 +0100
Message-ID: <951686861.22132.0.pluto.d4ee154e_at_news.demon.nl>

[Quoted] Three options:

- dump the sheets to a .csv file and use sql*loader
- use the Oracle ODBC driver to connect Excel directly to Oracle.
- As Oracle also comes with Oracle Objects for OLE for VB and VC++, you

[Quoted] could also write one program using the ODBC text driver, the ODBC driver for [Quoted] Excel and Oracle Objects for OLE to get the data loaded.

Hth,

Sybrand Bakker, Oracle DBA

Maggie <maggiezhou_at_hotmail.com> wrote in message news:89a026$961$1_at_web1.cup.hp.com...
> I am planing to create an oracle database. The database will receive from
> three difference data resources, two from excel spreadsheets, one from
flat
> file. My question is that does Oracle have a tool to import the Excel
> spreadsheet to Oracle database? Just like the MS SQL Server which has DTS
> to import Excel spreadsheet to table, I would like to know if Oracle have
> similar tool.
>
> Thanks.
>
>
Received on Sun Feb 27 2000 - 22:24:53 CET