Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Ang: Re:Import excelfile into Oracle table
Well it is always easier to ask here than do any research yourself isn't it.
John
-----Original Message-----
Brian_P_MacLean_at_eFunds.Com
Sent: 18 April 2002 17:04
To: Multiple recipients of list ORACLE-L
A simple search of Google:
http://www.google.com/search?sourceid=navclient&q=utl%5Ffile+example
Gives the following on the first page:
http://www.geocities.com/suresh_vemulapalli/utl.htm http://utplsql.sourceforge.net/Doc/admin.html http://www.classicity.com/oracle/htdocs/forums/ClsyForumID125/11.html#
http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/ut l_file.htm
Brian P. MacLean
Oracle DBA, OCP8i
Roland.Skoldbl om_at_ica.se To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent by: cc: root_at_fatcity.c Subject: Ang: Re:Import excelfile into Oracle table om 04/18/02 02:38 AM Please respond to ORACLE-L
Ok, thanks can you give me a good example on how to write the pl/sql code?
Thanks in advance.
Roland
emre.hancioglu_at_eu.effem.com_at_fatcity.com den 2002-04-18 01:10 PST
Sänd svar till ORACLE-L_at_fatcity.com
Sänt av: root_at_fatcity.com
Till: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Kopia:
Hi,
You'd better do the following:
* Convert the excel file to .csv file.
* Use utl_file package to read the data and insert to Oracle Tables.
M.Emre HANCIOGLU
Masterfoods GmbH
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Roland.Skoldblom_at_ica.se
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Brian_P_MacLean_at_eFunds.Com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Hallas
INET: john.hallas_at_hcresources.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Apr 18 2002 - 13:29:03 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
![]() |
![]() |