RE: how to load data from Excel sheet into Oracle tables using SQL*LOADER
- From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
- To: <vikramsingh120@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 17 May 2006 12:06:03 -0600
And here is a Perl recipe for scrubbing the data:
http://www.perl.com/cookbook/perlckbk2/solution.csp?day=1
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Reidy, Ron
Sent: Wednesday, May 17, 2006 11:25 AM
To: vikramsingh120@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: how to load data from Excel sheet into Oracle tables using
SQL*LOADER
If you are looking at an automated way to do this ...
Use Perl and the DBI and DBD::Excel modules. You could read the Excel
data using Perl, write it to a named pipe which would be the input to
the SQL*Loader process. Very easy to do and may help you with
automating the whole process.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of vikram singh
Sent: Wednesday, May 17, 2006 8:12 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: how to load data from Excel sheet into Oracle tables using
SQL*LOADER
Hi All,
Is there a way to load data from an Excel sheet into an Oracle table
using SQL*Loader? I know there must be.
Please, can anyone help me out how this can be achieved. Thanks in
advance.
Vikram.
________________________________
This electronic message transmission is a PRIVATE communication which
contains information
which may be confidential or privileged. The information is intended to
be for the use of the individual
or entity named above. If you are not the intended recipient, please be
aware that any disclosure,
copying, distribution or use of the contents of this information is
prohibited. Please notify the sender
of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0),
and then delete it from your system.
Other related posts:
