Re: Send data in excel files to oracle tables

Re: Send data in excel files to oracle tables

[ Follow Ups ] [ Post Followup ] [ Message Board ]

Posted by 'Steve' on July 28, 2001 at 00:27:09 EST:

In Reply to: Send data in excel files to oracle tables posted by 'Puntui Jackson' on July 27, 2001 at 19:53:27 EST:

Hi,
You can save the data in a comma(or any other character) delimited file from excel and then use SQL*Loader to load that data into your Oracle table in the schema.
Before loading, ensure that the tables in the schema are existing and your data (from the delimited files) satisfies all constraints imposed on your tables.

Steve

Follow Ups:

Post a Followup

Name:
E-Mail:
Subject:
Message: : Hi, : You can save the data in a comma(or any other character) delimited file from excel and then use SQL*Loader to load that data into your Oracle table in the schema. : Before loading, ensure that the tables in the schema are existing and your data (from the delimited files) satisfies all constraints imposed on your tables. : Steve