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 11:25:01 -0600
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:
