CSV File Example :

101,Andy,15-DEC-1995
102,Jack,01-MAY-1996
103,Rob,01-JUN-1996
104,Joe,01-JUN-1996

Create External Table as like as actual table and Move Data from External
Table to Actual Table.

1-CREATE OR REPLACE DIRECTORY EXT_TABLES AS 'C:\EXT_TABLES';

2-CREATE TABLE emp_ext
(
empcode NUMBER(4),
empname VARCHAR2(25),
hiredate date
)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_LOADER
DEFAULT DIRECTORY ext_tables
ACCESS PARAMETERS
(
RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY ','
MISSING FIELD VALUES ARE NULL
)
LOCATION ('emp_ext1.csv') -- (File should be place in
C:\EXT_TABLES folder)
)
REJECT LIMIT UNLIMITED;

3-Insert into emp_act
SELECT * FROM emp_ext;


Regards.

Muhammad Zubair
I.T. Dept.
Karachi,
Pakistan.





"Dejam Ruth " <oracledba-ezmlmshield-x8357698.[Email address protected]
28/07/2006 03:02 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
RE: transport data from excel to oracle.






Maybe I missed this but did anyone suggest putting out a .csv and loading
it with SQL*LOADER?

-----Original Message-----
From: Joann McMasters
[mailto:oracledba-ezmlmshield-x5884331.[Email address protected]
Sent: Thursday, July 27, 2006 3:37 PM
To: LazyDBA Discussion
Subject: Re: transport data from excel to oracle.


Easiest way is to import into Access and then from Access into Oracle.

Joann McMasters
Technical Services Coordinator
317-846-9521 x 318
Myers and Stauffer LC
9265 Counselors Row, Suite 200
Indianapolis, IN 46240-6419

>>> "Sharma B.M.- Basis - EITL (HAZ) "
<oracledba-ezmlmshield-x65393527.[Email address protected] 07/25/06 7:07
AM >>>

How can I transport/export the data from excel to oracle.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html




Oracle LazyDBA home page