Title: RE: Textfile into oracle
There is an option for filler fields in sqlldr
control fields.
This way you can skip unwanted fields in the csv
file.
Found it the other day when someone sent me a file to
load
with an extra field in the beginning of the
record.
The format for the field
Title: RE: Textfile into oracle
save
as txt first
-Original Message-From: Clinton Naude
[mailto:[EMAIL PROTECTED]]Sent: 06 June 2002 22:28To:
Multiple recipients of list ORACLE-LSubject: RE: Textfile into
oracle
Yes, use Sqlloader...
-Original Message- From
Because in Excel could be about 65k rows only, the easiest thing to do is
export Excel table as INSERT INTO ... script and run it from sqlplus.
JP
On Thursday 06 June 2002 12:03, you wrote:
Hallo,
I have this excelfile. Is it possible to import this into an oracle table.
This file is
There are some posibilities:
- Make an ORacle - Object program in Excel and insert data into Oracle.
Look at c:\orant\oo4o directory.
- Export data (Save as) from Excel to an csv file and them import into
ORacle using SQLLoader.
(Open file with wordpad).
-Mensaje original-
De: [EMAIL
Hello Roland,
The easiest way is to save it from excel as flat comma-separated text file.
Then you should use Oracle SQL*Loader tool and yes you will have to
pre-create the table with all fields you need. (99,9% that's what you need)
You cannot import .xls file into Oracle database directly
Title: RE: Textfile into oracle
Yes, use Sqlloader...
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 12:04 PM
To: Multiple recipients of list ORACLE-L
Subject: Textfile into oracle
Hallo,
I have this excelfile. Is it possible
Could anyone please give me an example on how the sqlloader script would look like ,
How many fields would it be,? I cant find anything ofthis in themanual. I have 100
fields in the excel file but only 9-10 field names...
Thanks in advance
Roland
Alexandre Gorbatchev [EMAIL
Roland,
If you are saying that you have 100 columns in the spreadsheet but you only
want to copy 9 columns into a table with 9 fields then you have 2 choices.
Reduce the spreadsheet to only 9 columns (by copying to another worksheet)
and then saving as a CSV file and importing by sqlloader. I
Roland,
At the risk of being the extremo de la broma to the OT lot.
The field names that you have specified in the excel file will need to be
deleted anyway. You will need a control file that loads the data in to a
table that has a hundred (100) fields. You will then need to save the excel
file