Re: Import data from excel

One way I have used successfully is to save the spreadsheet as a comma delimited file (.csv), transfer the file to the computer with the Oracle database, then use SQLLOADER to load the data into the database. The Oracle Utilities manual describes how to set up the control file that defines what table to load into and what columns to load.

ERTZ Olivier wrote:

> Hi,
> i'm looking for a tool that permit to import easily data from
> an excel form to an Oracle 7 table. A tool where "an unexperiment" user
> can set each columnn from the excel form to a column in the Oracle
> table, easely.
> does such a tool allready exist? That's my question
>
> Thank you for answering.
>
> ------------------------------ ERTZ Olivier -------------------------
> Etudiant en Maîtrise Informatique | Vacataire du CNRS-CGS
> UFR de Mathematique et Informatique | Centre de Géochimie de la Surface
> 67000 STRASBOURG - FRANCE | 1, rue Blessig - 67084 Strasbourg
> --> ertz_at_pascal.u-strasbg.fr <-- | --> ertz_at_illite.u-strasbg.fr <--
> -----------------------------------------------------------------------
> ...zORgLUb \|/ ____ \|/
> _at_~/ ,. \~@
> /_( \ _/ )_\ la revanche...
> \_U__/
Received on Wed Feb 11 1998 - 00:00:00 CET