Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Textfile into oracle
Yes, use Sqlloader...
-----Original Message-----
Sent: Thursday, June 06, 2002 12:04 PM
To: Multiple recipients of list ORACLE-L
Hallo,
I have this excelfile. Is it possible to import this into an oracle table.
This file is supposed to be located on unix machine from the beginning and
the import into an oracle table would be done from unix. How should I name
the fields in the oracle
table. I mean should I use the 9-10 different field names in the excelfile.
There is at least 100 different columns in this excelfile. Is it possible to
import a file like that into oracle table,
Please help me with some hints.
(See attached file: try.xls)
Thanks in advance
Roland
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Clinton Naude INET: clintonn_at_meb.co.za Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Thu Jun 06 2002 - 09:27:50 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).